Re: NZDT Question

"Mike C" <smith(dot)not(dot)western(at)gmail(dot)com> writes:
> I've just upgraded from Postgres 8.1.0 to 8.1.10 to update the NZ
> timezone changes, but it doesn't seem to make a difference (I've also
> patched linux). Ideas?

Hm, works for me:

Welcome to psql 8.1.10, the PostgreSQL interactive terminal.

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

regression=# set timezone to 'Pacific/Auckland';
SET
regression=# select '2007-10-01 06:12:40.097244+12'::timestamptz;
timestamptz
-------------------------------
2007-10-01 07:12:40.097244+13
(1 row)

What have you got "timezone" set to? Did you remember to restart
the postmaster after updating?

regards, tom lane