Re: daylight savings patches needed?

Joseph Shraibman <jks@selectacast.net> writes:

> Robert Treat wrote:
>
>> If you are running pre-8.0 versions you need to update your operating system
>> (as you indicated).  If you running an any 8.x version, you need to be on
>> the most current corresponding 8.x.y release.
>>
> So what happens if you have an old os with a new postgresql install? Will
> CURRENT_TIMESTAMP always return the correct value even if the system 'date'
> command is showing the wrong time?

This is something that isn't always good...  If your country changes the rules
to when DST starts / ends and PostgreSQL doesn't release a new version with
the changes (or a patch or...) then you would have to change this in two
places: your OS rules and PG's rules for timezones / DST / whatever.

--
Jorge Godoy      <jgodoy@gmail.com>