"Wright, George" <George.Wright@infimatic.com> writes:
> We seem to be having a time zone problem on a box configured for
> Singapore timezone. The OS is Suse10.2 PostgreSQL version is 8.1.5.
> Testing that timestamp string in PostgreSQL fails. It works ok with the
> other time zone.
It looks to me like 8.1 thinks SST is Swedish Summer Time (GMT+2),
so for your purposes that probably only "works" for rather small
values of "works". 8.1 doesn't know the SGT timezone abbreviation
at all.
In 8.1 there is no way to change this behavior short of compiling
your own version with a patched timezone abbreviations table.
You might consider updating to 8.2 or later, in which versions
the set of recognized TZ abbreviations is user-configurable.
FWIW, 8.4 and beyond will have SGT = GMT-8 in the default abbreviation
list.
regards, tom lane