Thread: 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=3D# 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
>

must be in 8.1.2 because i'm saying the same error in 8.1.1

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)