>From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
a timezone input string. However, this doesn't seem to work:
db=> INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost, seconds,
pseconds) VALUES ('10-05-2006 18:26:13 Europe/Moscow', 9407, 27362, 18516,
35361, 1606, 47);
ERROR: invalid input syntax for type timestamp with time zone: "10-05-2006
18:26:13 Europe/Moscow"
Any ideas as to what I'm doing wrong here?
Thanks.
--
Brandon
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
