k == [email protected] writes:
k> On Fri, Oct 06, 2006 at 09:10:33AM -0500, Brandon Metcalf wrote:
k> > >From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
k> > a timezone input string. However, this doesn't seem to work:
k> >
k> > 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);
k> > ERROR: invalid input syntax for type timestamp with time zone:
"10-05-2006 18:26:13 Europe/Moscow"
k> >
k> > Any ideas as to what I'm doing wrong here?
k> 8.0 only supports such timezones in the form:
k> '10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow';
k> Including it in the string is only supported from 8.2 beta onward. So
k> try that out and see how it goes.
That doesn't work, either.
db=> INSERT INTO synctimes (time, sreplica, shost, dreplica, dhost, seconds,
pseconds) VALUES ('10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow', 999999,
27362, 18516, 35361, 1606, 47);
ERROR: time zone "europe/moscow" not recognized
--
Brandon
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
