Re: preserving forensic information when we freeze - Mailing list pgsql-hackers

From Marko Kreen
Subject Re: preserving forensic information when we freeze
Date
Msg-id CACMqXCJ0OLDV6bfSj+QNrm2yZUaxYuXNzben5scWydLwX4C2Tg@mail.gmail.com
Whole thread Raw
In response to Re: preserving forensic information when we freeze  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
On Wed, Jul 3, 2013 at 8:07 PM, Andres Freund <andres@2ndquadrant.com> wrote:
> On 2013-07-02 16:29:56 -0400, Robert Haas wrote:
>> There's no possibility of getting confused here; if X is still around
>> at all, it's xmax is of the same generation as Y's xmin.  Otherwise,
>> we've had an undetected XID wraparound.
>
> Another issue I thought about is what we will return for SELECT xmin
> FROM blarg; Some people use that in their applications (IIRC
> skytools/pqg/londiste does so) and they might get confused if we
> suddently return xids from the future. On the other hand, not returning
> the original xid would be a shame as well...

Skytools/pqg/londiste use only txid_* APIs, they don't look at
4-byte xids on table rows.

-- 
marko



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: New regression test time
Next
From: Kevin Grittner
Date:
Subject: Re: refresh materialized view concurrently