Lists: | pgsql-bugs |
---|
From: | "nagash" <postgresql(at)nagash(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1500: child dead |
Date: | 2005-02-22 13:41:35 |
Message-ID: | 20050222134135.1894CF0B0F@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1500
Logged by: nagash
Email address: postgresql(at)nagash(dot)org
PostgreSQL version: 8.0.1
Operating system: RedHat
Description: child dead
Details:
site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
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.
tested on 2 servers and it show with exactly 'YYYYMonDD' if I write
SELECT to_char(NOW() - '2000-10-02'::date, 'YYYY');
it will be OK
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "nagash" <postgresql(at)nagash(dot)org> |
Cc: | pgsql-bugs(at)postgresql(dot)org, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Subject: | Re: BUG #1500: child dead |
Date: | 2005-02-23 16:12:00 |
Message-ID: | 19644.1109175120@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
"nagash" <postgresql(at)nagash(dot)org> writes:
> site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
> server closed the connection unexpectedly
Hmm, I get bad output rather than a core dump, but it certainly seems
like a "must fix" if a dump is possible. Karel, can you look into it?
regression=# select to_char('1605 days 12:09:35'::interval, 'YYYYMonDD');
to_char
-----------
0001(at)16
(1 row)
regression=#
regards, tom lane
From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | nagash <postgresql(at)nagash(dot)org>, pgsql-bugs(at)postgresql(dot)org, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Subject: | Re: BUG #1500: child dead |
Date: | 2005-02-23 16:32:21 |
Message-ID: | 421CB015.2050301@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
Tom Lane wrote:
> "nagash" <postgresql(at)nagash(dot)org> writes:
>
>>site_utf=# SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');
>>server closed the connection unexpectedly
>
>
> Hmm, I get bad output rather than a core dump, but it certainly seems
> like a "must fix" if a dump is possible. Karel, can you look into it?
I got sig-11 here (although that was with an 8.0 beta I had lying
around) - does it with intervals but not with dates.
--
Richard Huxton
Archonet Ltd