Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Any reason why postgres can't detect time zone on my machine
> automatically?
>> I'm guessing the TZ code isn't identifying Aussie timezones.
So what *is* your zone, exactly? I don't see how you expect us to
figure out why it's not matching when we don't know what it's not
matching.
There already are some debug printouts in CVS tip. If you set
log_min_messages to debug4 or debug5 you should get reams of
log messages about why each tested TZ setting didn't seem to match
the system's timezone. If you could send along the output for
the zones that seem like reasonable candidates to match, it'd help.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
