Thread: Unrecognized time zone name error.

This seems odd.  Any idea what's going on here?

template1=# SET TimeZone TO 'GMT';
ERROR:  unrecognized time zone name: "GMT"
template1=# SELECT version();
                                   version
-----------------------------------------------------------------------------
 PostgreSQL 8.1.5 on powerpc-ibm-aix5.3.0.0, compiled by GCC gcc (GCC)
3.3.2
(1 row)

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

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

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.