Joseph Shraibman <jks@xxxxxxxxxxxxxxx> 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@xxxxxxxxx>
