Re: nasty problem with redhat 6.2 + pg 7.02

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: leonbloy(at)sinectis(dot)com(dot)ar
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: nasty problem with redhat 6.2 + pg 7.02
Date: 2000-09-19 23:55:46
Message-ID: 17892.969407746@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

leonbloy(at)sinectis(dot)com(dot)ar writes:
> Tom Lane wrote:
>> I'll bet there is some bit of internal state somewhere that affects
>> the results. It could be inside libc, or it could be in Postgres.

> postgres, I would tend to think...
> For one thing I've just found out: the 'histeresis' effect occurs
> only WITHIN A CONNECTION:

Doesn't prove a thing. The libc state I'm thinking of would be
recomputed on first use within a given process, ie, per backend.
So we still have no idea if the problem is libc's or Postgres'.

Given that the problem seems to be specific to your timezone,
and Postgres itself knows very little about timezones, a libc bug
is well within the realm of possibility.

Is anyone else able to reproduce this misbehavior at a DST boundary?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Berkus 2000-09-20 00:08:27 Re: [GENERAL] Foreign Keys Help Delete!
Previous Message Timothy Covell 2000-09-19 23:49:23 Foreign Keys Help Delete!