"Karl O. Pinc" <kop@xxxxxxxx> 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
