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

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

"nagash" <postgresql (AT) nagash (DOT) org> writes:
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Ä@16
(1 row)

regression=#

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Tom Lane wrote:
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

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

SELECT to_char(NOW() - '2000-10-02'::date, 'YYYYMonDD');

Clear CRASH and autorestart.
Need fix :-|

pg 8.0.1 FreeBSD 5.2.1
Core size 3334144

Best regards,
Alexander Kirpa


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

If it's any help, on windows 8.0.0, I get a popup that says

'The instruction at "0x78001d90" referenced memory at "0x00000000". The
memory could not be read."

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg (AT) kgb (DOT) une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

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