Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] OID Question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Geoffrey <esoteric(at)3times25(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] OID Question
Date: 2004-11-11 21:01:46
Message-ID: 20041111210146.GA32254@wolff.to (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
On Thu, Nov 11, 2004 at 15:34:14 -0500,
  Geoffrey <esoteric(at)3times25(dot)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.

In response to

pgsql-novice by date

Next:From: GeoffreyDate: 2004-11-11 21:14:32
Subject: Re: version changes
Previous:From: Martijn van OosterhoutDate: 2004-11-11 20:42:57
Subject: Re: [NOVICE] OID Question

pgsql-general by date

Next:From: Dawid KuroczkoDate: 2004-11-11 21:03:48
Subject: Re: comp.database.postgresql.*
Previous:From: Martijn van OosterhoutDate: 2004-11-11 20:42:57
Subject: Re: [NOVICE] OID Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group