From: | Vikram Kulkarni <vkulkarn(at)brownforces(dot)org> |
---|---|
To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
Cc: | Vikram Kulkarni <vkulkarn(at)brownforces(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.4.2 Regression tests: test stats loops indefinately... |
Date: | 2004-05-04 14:51:30 |
Message-ID: | 20040504145130.GE30567@padu.brownforces.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, May 04, 2004 at 10:36:20AM +0200, Manfred Koizar wrote:
>On Mon, 3 May 2004 20:47:31 -0400, Vikram Kulkarni wrote:
>>
>> test=# SELECT timeofday();
>> timeofday
>> -------------------------------------
>> Wed Dec 31 16:00:00.591964 1969 PST
>> (1 row)
>> [...]
>> That obviously doesn't look right. Isnt' timeofday() supposed to return
>> the current time of day? The system clock is set correctly.
>
> Vik, I guess that on your platform time_t is smaller than long. Please
> compile and run the attached C program.
hmmm... on OpenBSD-3.5/sparc64, time_t is an int...
http://www.openbsd.org/cgi-bin/cvsweb/src/sys/arch/sparc64/include/ansi.h?rev=1.4&content-type=text/x-cvsweb-markup
The compiler is GCC 3.3.2 with ProPolice.
dt% ./a.out
old: >>Wed Dec 31 19:00:00.451903 1969 EST<<
new: >>Tue May 04 10:41:12.455457 2004 EDT<<
But on my older, OpenBSD-3.1/i386 computer, time_t is defined in the
same way, though the compiler is GCC 2.95.3. and the two dates printed
there match. hmm...
-Vik
--
vikram vinayak kulkarni Happiness is a Dunkin Donut.
vkulkarn(at)brownforces(dot)org -Jason Zych
http://vvk.brownforces.org
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2004-05-04 14:54:14 | Re: set autocommit TO FALSE on postgres 7.4 |
Previous Message | Michal Hlavac | 2004-05-04 14:39:55 | Variable in PostgreSQL 7.4.x |