|
Home > Archive > PostgreSQL Bugs > January 2006 > BUG #2152: psql crash reproducible
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BUG #2152: psql crash reproducible
|
|
| Andreas Kretschmer 2006-01-06, 11:24 am |
|
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,1
0)||'days')::interva
l)::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
| |
| Tom Lane 2006-01-06, 11:24 am |
| "Andreas Kretschmer" <andreas@a-kretschmer.de> writes:
> test=# select x from (select extract(dow from ('2006/01/01'::date +
> (generate_series(0,1
0)||'days')::interva
l)::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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Jaime Casanova 2006-01-06, 11:24 am |
| On 1/6/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Andreas Kretschmer" <andreas@a-kretschmer.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
>
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
|
|
|
|
|