[GENERAL] Unrecognized time zone name error.

2006-12-12 Thread Brad Nicholson
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

Re: [GENERAL] Unrecognized time zone name error.

2006-12-12 Thread Tom Lane
Brad Nicholson [EMAIL PROTECTED] 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)?

Re: [GENERAL] Unrecognized time zone name error.

2006-12-12 Thread Brad Nicholson
On Tue, 2006-12-12 at 11:13 -0500, Tom Lane wrote: Brad Nicholson [EMAIL PROTECTED] 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/