Re: OID order = INSERT order? - Mailing list pgsql-general

From Roland Roberts
Subject Re: OID order = INSERT order?
Date
Msg-id m2k7lbv491.fsf@kuiper.rlent.pnet
Whole thread Raw
In response to Re: OID order = INSERT order?  (Elaine Lindelef <eel@cognitivity.com>)
Responses Re: OID order = INSERT order?
List pgsql-general
>>>>> "Elaine" == Elaine Lindelef <eel@cognitivity.com> writes:

    >> elein <elein@norcov.com> writes:
    >> > In 7.3b1, the oids of a row do not change on update according
    >> > to my experiment.  I had thought they did.  Is this new with
    >> > 7.3?

    >> No, same as it ever was.

    Elaine> OIDs only change if you drop from a table and then
    Elaine> reinsert the data. Perhaps that is what you were thinking
    Elaine> of?

Didn't they (appear to) change long ago in the dark ages when rows had
an epoch attached to them so you were never really updating anything?

roland
--
               PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD                             RL Enterprises
roland@rlenter.com                     76-15 113th Street, Apt 3B
roland@astrofoto.org                       Forest Hills, NY 11375

pgsql-general by date:

Previous
From: Roland Roberts
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL
Next
From: Bruce Momjian
Date:
Subject: Re: Postmaster Uptime