Re: Unrecognized time zone name error.

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unrecognized time zone name error.
Date: 2006-12-12 16:49:17
Message-ID: 1165942158.15903.86.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2006-12-12 at 11:13 -0500, Tom Lane wrote:
> Brad Nicholson <bnichols(at)ca(dot)afilias(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2006-12-12 16:50:53 Re: resetting sequence to cur max value
Previous Message Tomi N/A 2006-12-12 16:47:34 a question on SQL