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!