"Karl O. Pinc" <kop(at)meme(dot)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