BUG #5634: timezone/trigger issue

The following bug has been logged online:

Bug reference:      5634
Logged by:          Jaseb Betts
Email address:      jasen@free.net.nz
PostgreSQL version: 8.3
Operating system:   Windows xp 32 bit
Description:        timezone/trigger issue
Details:

/pgsql/src/timezone/tznames/Default/ doesn't include CAT
this is the timezone used in South Africa (on windows xp platform
it's listed as "(GMT+02:00) Harare, Pretoria" in the timezone dialog)

  http://www.worldtimezone.com/time-africa12.php

As a result with 8.3 on windows some timestamp stuff does not work (in south
africa).

also:
db=> select now();
             now
-----------------------------
 27/08/2010 04:41:07.921 CAT
(1 row)

db=> select now()::text::timestamp;
ERROR:  invalid input syntax for type timestamp: "27/08/2010 04:41:23.375
CAT"

Also if I do NEW.foo=now() in a before update trigger and NEW.foo is of type
TIMEZONE, when I cause the trigger to run I get the same error message as
above.


db=>show lc_time;
 lc_time
---------
 C
 (1 row)

copying the "CAT" entry from Africa.txt into Default seems to fix this.

It suprises me that the timezone comes out as CAT onstead of +02, but I
guess
that's windows doing it's own thing.

I note that EST is apparently also a Brazilian timezone that differs from
the
other two ESTs, but don't know if any users are effected.

 http://www.worldtimezone.com/wtz-names/wtz-est.html