Re: oids as primary keys?

Hi,

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!
http://smallbusiness.yahoo.com/resources/