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/ > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
