Nairobi time zone fails in 7.4

[Karl O. Pinc]

Hi,

In 7.3 I was able to do:
ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
a nice Posix TZ value (FYI UTC+3 w. no daylight savings time).

In 7.4 this no longer works. I see some UTC+3 time zones
in the 7.4 docs, but how am I to know that they correspond
to Kenyan time, especially with respect to daylight
savings and other goofyness? What's the right thing to do?

Thanks.

Karl <ko*@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

"Karl O. Pinc" <ko*@meme.com> writes:

In 7.3 I was able to do:
ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
a nice Posix TZ value (FYI UTC+3 w. no daylight savings time). In 7.4 this no longer works.

I don't believe it worked in 7.3 either, but before 7.4 we didn't really
detect whether the system timezone library recognized the name or not.

I think the usual spelling for this zone name is 'Africa/Nairobi'.
Certainly that's what PG 8.0 will take.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Karl O. Pinc]

On 2004.11.15 10:42 Tom Lane wrote:

"Karl O. Pinc" <ko*@meme.com> writes:

In 7.3 I was able to do:
ALTER DATABASE babase SET "TimeZone" TO 'Nairobi';
a nice Posix TZ value (FYI UTC+3 w. no daylight savings time).

I think the usual spelling for this zone name is 'Africa/Nairobi'.
Certainly that's what PG 8.0 will take.

Thanks! That works in 7.4.

Karl <ko*@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly