Re: Unrecognized time zone name error. - Mailing list pgsql-general

From Brad Nicholson
Subject Re: Unrecognized time zone name error.
Date
Msg-id 1165942158.15903.86.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: Unrecognized time zone name error.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 2006-12-12 at 11:13 -0500, Tom Lane wrote:
> Brad Nicholson <bnichols@ca.afilias.info> writes:
> > This seems odd.  Any idea what's going on here?
>
> > template1=# SET TimeZone TO 'GMT';
> > ERROR:  unrecognized time zone name: "GMT"
>
> Worksforme.  Perhaps you are missing the /usr/share/pgsql/timezone/
> directory (your path might vary)?
>
>             regards, tom lane

So it's documented in the archives, the GMT file was missing from the
directory you mentioned.  Thx.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-general by date:

Previous
From: "Tomi N/A"
Date:
Subject: a question on SQL
Next
From: "Marc Mamin"
Date:
Subject: Re: resetting sequence to cur max value