Hello all,
We are experiencing an error while trying to insert a row containing a date
string including timezone information:
acctvoip=> select version();
version
----------------------------------------------------------------
PostgreSQL 7.3 on sparc-sun-solaris2.6, compiled by GCC 2.95.3
(1 row)
acctvoip=> create table test (testdate timestamp with time zone);
CREATE TABLE
acctvoip=> insert into test values ('12:34:08.689 ART Fri Jan 10 2003');
ERROR: Bad timestamp external representation '12:34:08.689 ART Fri Jan 10
2003'
acctvoip=> insert into test values ('12:34:08.689 AWT Fri Jan 10 2003');
INSERT 56150645 1
So the problem arises when we try to use ART, which is the usual symbol for
Argentina Time (GMT-3). AWT, which is described in the docs as "unknown",
works just fine.
Our problem is that we have a lot of data sources which are already
configured to use ART as their TZ, so it would be a real pain to change
them all.
FWIW, I browsed the source tree and found that "art" is already defined in
datetime.c and appears to be included:
$ grep -in '"ART"' /opt/pgsql/src/postgresql-7.3/src/backend/utils/adt/datetime.c
119: {"art", TZ, NEG(12)}, /* Argentina Time */
But it doesn't work, as shown above. Any hints?
thanks in advance,
cl.