Re: [GENERAL] OID Question - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: [GENERAL] OID Question
Date
Msg-id 20041111210146.GA32254@wolff.to
Whole thread Raw
In response to Re: [GENERAL] OID Question  (Geoffrey <esoteric@3times25.net>)
List pgsql-novice
On Thu, Nov 11, 2004 at 15:34:14 -0500,
  Geoffrey <esoteric@3times25.net> wrote:
>
> "Whenever an application makes use of OIDs to identify specific rows of
> a table, it is recommended to create a unique constraint on the oid
> column of that table, to ensure that OIDs in the table will indeed
> uniquely identify rows even after counter wraparound."
>
> Am I reading this correctly?  If I place a unique constraint on the oid
> column, I will not have to worry about oid wrap around?

No. The unique constraint may result in a transaction failing that
wouldn't otherwise fail and your application needs to be able to handle
this case.

pgsql-novice by date:

Previous
From: "Kevin B."
Date:
Subject: version changes
Next
From: Geoffrey
Date:
Subject: Re: version changes