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.