The following bug has been logged online:

Bug reference: 3997
Logged by: Aaron Mizrachi
Email address: unmanarc@gmail.com
PostgreSQL version: 8.3.0
Operating system: Windows
Description: Venezuela TIMEZONE
Details:

venezuela have a new timezone (-4:30 hrs).

File postgresql-8.3.0/src/timezone/tznames/America.txt:299 does not reflect
that change:

VET -14400 # Venezuela Time

(-14400 = -4:00)

The right value is: -16200 # -4:30 hrs

---------------------
Check:
http://support.microsoft.com/kb/938977
http://news.bbc.co.uk/2/hi/americas/7134927.stm

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

"Aaron Mizrachi" <unmanarc@gmail.com> writes:
> venezuela have a new timezone (-4:30 hrs).

Done. It's a bit unfortunate that they kept the same abbreviation
instead of choosing a new one, but I don't suppose that database
weenies get any say about that ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate