Re: determining supported timezones

Yes, I think you could argue this. In the old system, we could tell
them to look in the OS-supported timeszones. Now we have to tell them
to look in data/share/timezone. Is that enough or not?

---------------------------------------------------------------------------

Robert Treat wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073