On Fri, Oct 06, 2006 at 09:10:33AM -0500, Brandon Metcalf wrote:
> >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?8.0 only supports such timezones in the form: '10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow'; Including it in the string is only supported from 8.2 beta onward. So try that out and see how it goes. Have a nice day, -- Martijn van Oosterhout <[email protected]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
