"Brandon Metcalf" <[EMAIL PROTECTED]> writes:
> k == kleptog@svana.org writes:
> k> 8.0 only supports such timezones in the form:
> k> '10-05-2006 18:26:13' AT TIME ZONE 'Europe/Moscow';
> That doesn't work, either.
I think AT TIME ZONE was updated to allow long-form tz names in 8.1.
In 8.0 you
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, srep
"Brandon Metcalf" <[EMAIL PROTECTED]> writes:
> From what I can tell, PostgreSQL 8.0.3 should support Europe/Moscow as
> a timezone input string.
Sorry, no. That's actually new for 8.2.
regards, tom lane
---(end of broadcast)--
am Fri, dem 06.10.2006, um 9:10:33 -0500 mailte Brandon Metcalf folgendes:
> >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,
> second
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)
>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, 1
