| From: | "Mike C" <smith(dot)not(dot)western(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: NZDT Question |
| Date: | 2007-09-26 03:42:16 |
| Message-ID: | bd0eabd0709252042i65de73f7v2b45cfabf31d1ca5@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 9/26/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2007-09-26 05:39:05 | Re: Why the ERROR: duplicate key violates unique constraint "master_pkey" is raised? - Is this a Bug? |
| Previous Message | Tom Lane | 2007-09-26 03:19:58 | Re: NZDT Question |