Re: [HACKERS] Anyone using "POSIX" time zone offset capability? - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] Anyone using "POSIX" time zone offset capability?
Date
Msg-id 8445.1161047659@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anyone using "POSIX" time zone offset capability?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I wrote:
> ... I'm not entirely convinced that it really is a POSIX-sanctioned
> notation, either --- the POSIX syntax the zic code knows about is
> different.

Actually, I take that back: it is a subset of the same notation, but
the datetime.c code is misinterpreting the spec!

The POSIX timezone notation as understood by the zic code includes
the possibility of

    zoneabbrev[+-]hh[:mm[:ss]]

but the meaning is that hh:mm:ss *is* the offset from GMT, and
zoneabbrev is being defined as the abbreviation for that offset.
What the datetime.c code is doing is trying to find the zoneabbrev
in a built-in timezone table, and then adding the two together.
This is simply wacko.

Given where the code stands now, I think the best solution is to
rip out DecodePosixTimezone and instead pass the syntax off to the
zic code (which can handle it via tzparse()).  Since the datetime
input parser is ultimately only interested in the GMT offset value,
this would mean that the zoneabbrev part would become a noise word.

            regards, tom lane

pgsql-general by date:

Previous
From: "Andras Simon"
Date:
Subject: Permission problem with create tablespace
Next
From: Douglas McNaught
Date:
Subject: Re: Permission problem with create tablespace