Time zone HADT timestamp syntax error in trigger
От | John Smithus |
---|---|
Тема | Time zone HADT timestamp syntax error in trigger |
Дата | |
Msg-id | f4eea4e90904301138m1ebc9ec5u770c8ba9adea499e@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Time zone HADT timestamp syntax error in trigger
|
Список | pgsql-general |
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 "timestamp (0) with time zone", but for testing, I am able to duplicate the results using the trigger example located at the following location: http://www.postgresql.org/docs/8.3/interactive/plpgsql-trigger.html#PLPGSQL-TRIGGER-EXAMPLE I create a new database, create the example table, function, and trigger, and then perform the following query is psql: INSERT INTO emp (empname, salary) VALUES ('John', '3000'); It immediately returns with: ERROR: invalid input syntax for type timestamp: "04/30/2009 08:48:05.760442 HADT" CONTEXT: PL/pgSQL function "emp_stamp" line 16 at assignment As I mentioned, I'm actually targeting a column type of "timestamp (0) with time zone", but I'd like to know what modification should be done to that trigger example to allow the assignment to succeed. Any advice is greatly appreciated. Thank you very much!
В списке pgsql-general по дате отправления: