Nick Martens <nick80@xs4all.nl> writes:
> here it is, including the defenition of the table and view in question, as it
> seems it coredumped when it tried to execute a query using a typecast from
> timestamptz to timestamp, after setting an invalid timezone, hope it helps.
Ah, that's the missing bit:
regression=# select now()::timestamp;
now
----------------------------
2006-01-10 14:44:31.517463
(1 row)
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=# select now()::timestamp;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Seems to work fine in the 7.4, 8.1, and HEAD branches ... but 8.0 is
busted. Thanks for the report!
regards, tom lane