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

Re: oids as primary keys?

From: Andres Ledesma <alchir(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: oids as primary keys?
Date: 2005-04-15 19:26:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

If you're creating a database, you probably have a
data model about that 'thing' you're trying to craft
your system upon. 

If this table in which you used the oids  as PK
correspond to any object of your model, you better use
 a unique attribute to identify that object, keeping
the semantics and the spirit of the relational model.

Just an idea !

Andres ...

--- Cima <ruel(dot)cima(at)facinf(dot)uho(dot)edu(dot)cu> wrote:
> 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.
> thanx.
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org

Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!

pgsql-novice by date

Next:From: T- BoneDate: 2005-04-15 21:06:01
Subject: Re: Simple function closes connection to server
Previous:From: CimaDate: 2005-04-15 19:04:01
Subject: file oids

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