Alessio Bragadini <alessio@albourne.com> writes:
> village=# set TimeZone TO PST;
I'm guessing that's not a legal timezone name on your platform.
On my box I have to spell it "PST8PDT" ... note that the displayed
abbreviation is not the same as the name used to set the timezone.
regards, tom lane