From: | James G Wilkinson <jgw(at)alpinegeophysics(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Time Zone Setting |
Date: | 2006-07-28 20:59:55 |
Message-ID: | 44CA7ACB.5070506@alpinegeophysics.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I just ran into a small mystery. I am trying to set the time zone
during my session and here is what happens:
megan=# set timezone to 'EST'
megan=# do some work here
megan=# set timezone to 'PST'
ERROR: unrecognized time zone name: "PST"
megan=# set timezone to 'PDT'
ERROR: unrecognized time zone name: "PDT"
megan=# set timezone to 'MST'
megan=# set timezone to 'GMT'
megan=# select version();
version
--------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
4.0.0 20050519 (Red Hat 4.0.0-8)
My default timezone is PDT for this time of year.
I am a bit mystified. Any suggestions?
Regards,
Jim
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-07-28 22:20:34 | Re: Time Zone Setting |
Previous Message | Andrew Hammond | 2006-07-28 20:51:52 | Re: Tables Locks Quetion or Strictlly subsequent numbers |