From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Timezone library on Unix |
Date: | 2004-05-01 03:25:02 |
Message-ID: | 200405010325.i413P2P01686@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
I am getting farther with the timezone library on Unix.
First, I realized that the share/timezone library doesn't have a
localtime file by default, so the PostgreSQL server doesn't know the
local timezone. I added that and got:
test=> select current_timestamp;
timestamptz
-------------------------------
2004-04-30 18:52:14.930852+00
(1 row)
test=> select timeofday();
timeofday
-------------------------------------
Fri Apr 30 22:52:17.686324 2004 EDT
(1 row)
(How are we going to deal with the missing localtime file?)
It is obviously seeing my local timezone, but it doesn't know that it is
+04. It is at least reading the right directory.
To test, define USE_PGTZ in pg_config.h and set USE_PGTZ=yes in Makefile.global.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-01 03:36:36 | Re: Current CVS tip segfaulting |
Previous Message | Andrew Dunstan | 2004-05-01 03:18:02 | Re: win32 build and test issues |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-05-01 03:45:34 | Re: width_bucket() per SQL2003 (WIP) |
Previous Message | Andrew Dunstan | 2004-05-01 03:22:52 | Re: mingw regression test fixes |