Re: oids as primary keys?

Поиск
Список
Период
Сортировка
От Andres Ledesma
Тема Re: oids as primary keys?
Дата
Msg-id 20050415192651.19484.qmail@web30308.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на oids as primary keys?  ("Cima" <ruel.cima@facinf.uho.edu.cu>)
Список pgsql-novice
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.cima@facinf.uho.edu.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@postgresql.org
>



__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Cima"
Дата:
Сообщение: file oids
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: query syntax question