timestamps in Australia

set timezone to 'Australia/Sydney';
set timezone_abbreviations to 'Australia';
set datestyle to 'SQL,DMY';

select '2011-04-03 01:00'::timestamptz+generate_series(0,3)*'1h'::interval,generate_series(0,3);

notice how the middle two look the same.
(this is Australias DST change-back)

This has the potential to cause all sorts of problems, especially in
triggers where now() seems to return a string which gets
reinterpreted...

other than setting datestyle to 'ISO,DMY' is there a way to fix this?

How do the Australians handle this?

Apparently the zic database (where the string 'EST' originates has
been this way since 2004.)



select '2011-04-03 02:00:00 EST'::timestamptz - '1h':: interval;  -- invariant ?

--
ɹǝpun uʍop ɯoɹɟ sƃuıʇǝǝɹ⅁