Re: Nairobi time zone fails in 7.4 - Mailing list pgsql-general

From Tom Lane
Subject Re: Nairobi time zone fails in 7.4
Date
Msg-id 8739.1100536968@sss.pgh.pa.us
Whole thread Raw
In response to Nairobi time zone fails in 7.4  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: Nairobi time zone fails in 7.4
List pgsql-general
"Karl O. Pinc" <kop@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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: "q" with psql display paging dumps out of psql
Next
From: "Karl O. Pinc"
Date:
Subject: Re: Nairobi time zone fails in 7.4