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

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)?

[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