Re: 7.4.2 Regression tests: test stats loops indefinately...

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

In response to

Responses

Browse pgsql-general by date

  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