Package: postgresql-8.1 Version: 8.1.9-0etch1 Severity: important As of 2007-12-09 07:00:00 UTC, Venezuela will shift from -4:00 to -4:30. The version of PostgreSQL currently available in Debian Etch does not handle it correctly making date manipulation unaccurate.
Attached a patch that fixes the problem. I placed the patch in debian/patches, rebuilt the whole thing, ran the regression tests and specifically tested the timezone related calculations and they work fine. -- Ernesto Hernández-Novich - Linux 2.6.18 i686 - Unix: Live free or die! Geek by nature, Linux by choice, Debian of course. If you can't aptitude it, it isn't useful or doesn't exist. GPG Key Fingerprint = 438C 49A2 A8C7 E7D7 1500 C507 96D6 A3D6 2F4C 85E3
diff -ruN postgresql-8.1.9/src/timezone/data/southamerica postgresql-8.1.9-old/src/timezone/data/southamerica --- postgresql-8.1.9/src/timezone/data/southamerica 2007-04-19 18:44:44.000000000 -0400 +++ postgresql-8.1.9-old/src/timezone/data/southamerica 2007-12-06 14:55:51.024121641 -0400 @@ -1101,4 +1101,5 @@ Zone America/Caracas -4:27:44 - LMT 1890 -4:27:40 - CMT 1912 Feb 12 # Caracas Mean Time? -4:30 - VET 1965 # Venezuela Time - -4:00 - VET + -4:00 - VET 2007 Dec 09 03:00 + -4:30 - VET
