Re: Buggy timestamp generation code in PG 7.4.5 on FreeBSD 4.10

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Clift <jc(at)telstra(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Buggy timestamp generation code in PG 7.4.5 on FreeBSD 4.10
Date: 2004-10-10 19:54:11
Message-ID: 13001.1097438051@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Justin Clift <jc(at)telstra(dot)net> writes:
> Running PG 7.4.5 on FreeBSD 4.10, we've found what looks to be buggy
> output from the timestamp code used to generate logfile entries.

The code involved is

curtime = time(NULL);

strftime(buf, sizeof(buf),
"%Y-%m-%d %H:%M:%S ",
localtime(&curtime));

so this bug report ought to go to the FreeBSD libc folk.

I believe there are known problems with BSD kernels sometimes returning
wrong clock readings on SMP machines, so that might be a place to look too.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-10-10 19:56:44 Re: postgres 8.0.0beta3 problem
Previous Message Tom Lane 2004-10-10 19:48:47 Re: Installation Error