Re: oids as primary keys?

Le Saturday 16 April 2005 00:42, Cima a écrit :
> hi ,
>
> someone has drawn my attention to the fact that oids may not be such a good
> idea to set as a primary key in a table. i have designed a relativley large
> database and defined oids as primary keys. i would like your opinions or
> recomendations on this.

It's surelly me, I reply to you directly instead to the list :(

About this I find where I read the warning:
http://www.postgresql.org/docs/8.0/interactive/datatype-oid.html

where you can read:

"The oid type is currently implemented as an unsigned four-byte integer.
Therefore, it is not large enough to provide database-wide uniqueness in
large databases, or even in large individual tables. So, using a user-created
table's OID column as a primary key is discouraged. OIDs are best used only
for references to system tables."

Notice it is maybe not a problem for you currently.