BUG #2152: psql crash reproducible
The following bug has been logged online:
Bug reference: 2152
Logged by: Andreas Kretschmer
Email address: andreas@a-kretschmer.de
PostgreSQL version: 8.1.0
Operating system: Debian/Linux
Description: psql crash reproducible
Details:
i wrote a wrong query, and psql crash:
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
test=# select x from (select extract(dow from ('2006/01/01'::date +
(generate_series(0,10)||'days')::interval)::date)) x;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
I know, the query is wrong, but the client lost the connection. I'm not a
hacker, but i think, this is a bug, in the client or in the server, i don't
know.
Btw.: PG is very great! Thanks all developers for PostgreSQL!
"Andreas Kretschmer" <andreas@a-kretschmer.de> writes:
test=# select x from (select extract(dow from ('2006/01/01'::date +
(generate_series(0,10)||'days')::interval)::date)) x;
server closed the connection unexpectedly
Works for me as of 8.1 branch tip, so the fix is in either 8.1.1 or
8.1.2.
regards, tom lane
On 1/6/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Andreas Kretschmer" <andreas@a-kretschmer.de> writes:
test=# select x from (select extract(dow from ('2006/01/01'::date +
(generate_series(0,10)||'days')::interval)::date)) x;
server closed the connection unexpectedlyWorks for me as of 8.1 branch tip, so the fix is in either 8.1.1 or
8.1.2.regards, tom lane
must be in 8.1.2 because i'm saying the same error in 8.1.1
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)