Europe/Moscow timezone - Mailing list pgsql-general

From Brandon Metcalf
Subject Europe/Moscow timezone
Date
Msg-id Pine.LNX.4.58L.0610060904040.1921@cash.us.nortel.com
Whole thread Raw
Responses Re: Europe/Moscow timezone
Re: Europe/Moscow timezone
Re: Europe/Moscow timezone
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postgresql /var fill
Next
From: Robby Russell
Date:
Subject: Re: pg web hosting with tsearch2?