I figured this all out; turns out they were related.
I had set my timezone in the postmaster to Poland long ago and forgot,
and that is why both the abstime and show timezone produced strange
results. Sorry.
---------------------------------------------------------------------------
Bruce Momjian wrote:
> Does anyone know why this returns 0 and not 3600?
>
> test=> select '1970-01-01 01:00:00'::timestamp::abstime::int4;
> int4
> ------
> 0
> (1 row)
>
> My time(2) manual page says:
>
> The time() function returns the value of time in seconds since 0
> hours, 0 minutes, 0 seconds, January 1, 1970, Coordinated Universal Time.
>
> Also, why does my TimeZone show as Poland?
>
> test=> SHOW TimeZone;
> TimeZone
> ----------
> Poland
> (1 row)
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 359-1001
> + If your life is a hard drive, | 13 Roberts Road
> + Christ can be your backup. | Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073