Time Zone Setting

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

Responses

Browse pgsql-novice by date

  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