On 9/26/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
>
> 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?
Aha! Thanks... when I ran set timezone, it did not recognize
'Pacific/Auckland'. I hadn't installed share/timezone in correct
location. Works great now!
Cheers,
Mike
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
