Re: [GENERAL] Time zone HADT timestamp syntax error in trigger

2009-05-01 Thread Tom Lane
John Smithus writes: > [ 'HADT' is not recognized as a timezone abbreviation ] > The server is running PostgreSQL 8.3.7 on an AMD64 Gentoo Linux > machine. The system time zone is set to 'America/Adak' and datestyle > is set to 'sql, mdy' in postgresql.conf. Not every timezone abbreviation in the

[GENERAL] Time zone HADT timestamp syntax error in trigger

2009-04-30 Thread John Smithus
Greetings! I'm encountering an "invalid input syntax for type timestamp" error in a trigger. The server is running PostgreSQL 8.3.7 on an AMD64 Gentoo Linux machine. The system time zone is set to 'America/Adak' and datestyle is set to 'sql, mdy' in postgresql.conf. The target column type is "ti