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>