Re: OID and PK/FK KEYS
От | Kevin Barnard |
---|---|
Тема | Re: OID and PK/FK KEYS |
Дата | |
Msg-id | b068057c041020135920697ae@mail.gmail.com обсуждение исходный текст |
Ответ на | OID and PK/FK KEYS (kilomegabyte@freemail.it (Raffaele Spizzuoco)) |
Список | pgsql-general |
A better solution is to use the serial data type. OID is depreciated and may go away. http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-SERIAL On 19 Oct 2004 07:54:36 -0700, Raffaele Spizzuoco <kilomegabyte@freemail.it> wrote: > Hi! > > I'm from Italy, and sorry about my english... > I have a question that I know it is already said in the groups but I > have however some doubts > I have seen it is technically possible to use OID as PRIMARY KEY and > as FOREIGN KEY but it is correct to do so for the database's logical > integrity? > Is it better I use in any case other keys and not oid to avoid the > possible wraparound? or the wraparound is an extreme case and so I can > use quietly OID as PRIMARY and FOREIGN KEY? > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: