Re: Timezones (in 8.5?) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Timezones (in 8.5?)
Date
Msg-id 200911291309.nATD93G10824@momjian.us
Whole thread Raw
In response to Re: Timezones (in 8.5?)  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth wrote:
> >>>>> "Bruce" == Bruce Momjian <bruce@momjian.us> writes:
> 
>  Bruce> I think there is general agreement that we should have a
>  Bruce> timezone data type which validates against
>  Bruce> pg_timezone_names().name.
> 
> What happens when pg_timezone_names output changes? (which it can do,
> especially if the install is using the OS tzdata; even if not using OS
> tzdata, it's not expected to be stable even between point releases)

Uh, wow, yea, that would invalidate stored data --- yuck.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: cvs chapters in our docs
Next
From: Gokulakannan Somasundaram
Date:
Subject: A small issue in CommentCast function