Re: determining supported timezones - Mailing list pgsql-general

Well, looking at Tom's nearby post I suspect putting the data into the
database won't fly to far, so I guess we just need to update the docs and be
sure to mention the potential compatability issue in the release notes.

Robert Treat

On Wednesday 14 July 2004 23:36, Bruce Momjian wrote:
> 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

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