Re: Europe/Moscow timezone

k == kleptog@svana.org 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:13Europe/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'
ATTIME ZONE 'Europe/Moscow', 999999, 27362, 18516, 35361, 1606, 47); 
  ERROR:  time zone "europe/moscow" not recognized

--
Brandon