Re: determining supported timezones - Mailing list pgsql-general

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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073