The following bug has been logged online:
Bug reference: 1232
Logged by: John R Pierce
Email address: pierce@hogranch.com
PostgreSQL version: 7.4.2
Operating system: Linux 2.4.9
Description: Singapore Timezone missing
Details:
The timezone designation SGT is not recognized on inserts to "timestamp with
time zone" fields.
In file src/backend/utils/adt/datetime.c SGT is missing/undefined. it
should be...
{"sgt", TZ, POS(32)}, /* Singapore Time */
(i.e UTC+0800, no daylight time)