Re: More time zones

Bruce Momjian wrote:
> Christopher Kings-Lynne wrote:
> > > No, the Australians complained about the compile-time flag, and were
> > > very happy when it became a GUC parameter. I only mentioned to say that
> > > conflicting timezone issues are obviously a problem for some, and we did
> > > resolve it with GUC.
> >
> > OK, I've just realised I haven't set our server to use Australian
> > timezones - how do you do this with GUC? Can I put something in
> > postgresql.conf? I don't want to issue an extra query for every connection
> > to set it. I had a look at the timezone section of the manual and didn't
> > see anything about it...?
>
> Hmm, let's see... Hmm, I don't see anything. Maybe it isn't there. Oh,
> there it is:
>
> #australian_timezones = false
>
> Is that it? I think so. I am not 100% sure. Yes, I think that is it.
>
> :-)
>
> Smiley's all around. :-)

I am sorry Christopher. I just couldn't help myself. Yes, it is
australian_timezones in postgresql.conf. No need to set it for every
client. Make sure you remove the # comment character and set it to
true.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026