The following bug has been logged online:

Bug reference: 2152
Logged by: Andreas Kretschmer
Email address: andreas (AT) a-kretschmer (DOT) 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!

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

"Andreas Kretschmer" <andreas (AT) a-kretschmer (DOT) de> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

On 1/6/06, Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:
must be in 8.1.2 because i'm saying the same error in 8.1.1

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings