Timezone library on Unix

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

In response to

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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