Re: determining supported timezones

Can I argue that this is a missing implementation detail needed for 7.5? My
grounds being that we are potentially breaking backwards compatability by
changing the supported timezones but giving the user no easy way to determine
just what is supported.

Robert Treat

On Wednesday 14 July 2004 18:25, Bruce Momjian wrote:
> TODO?
>
> * Show supported times
>
> ---------------------------------------------------------------------------
>
> Magnus Hagander wrote:
> > >I am trying to figure out if there is a way to determine the timezones
> > >supported in postgresql from within the database. If you look at
> > >http://www.postgresql.org/docs/7.4/static/datetime-keywords.html it
> > >notes that time zone information is system dependent, (I interpret to
> > >mean that anything I find in /usr/share/zoneinfo on linux should be
> > >supported, can someone confirm that?)
> >
> > Yes, that should be it.
> >
> > > so how can an external app
> > >determine which timezones are supported given that it could be deployed
> > >against postgresql databases on different OS's. My current thinking is
> > >that there is no way to get a complete list, but perhaps the list of
> > >known timezones (as listed in the docs) are available? If it is not,
> > >will this change in 7.5 now that we have a standard timezone library we
> > >are using across platforms?
> >
> > In 7.5, you can check the files in <pgdir>/share/timezone. There is no
> > function in the backend ATM to show them. I've been thinking of adding
> > one (as a system view), but didn't get around to it before freeze. (It'd
> > basically loop over the files in the directory)
> >
> > //Magnus
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL