The following bug has been logged online:
Bug reference: 1500
Logged by: nagash
Email address: postgresql@nagash.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