Re: using OID as primary key
От | JanWieck@t-online.de (Jan Wieck) |
---|---|
Тема | Re: using OID as primary key |
Дата | |
Msg-id | 200007211157.NAA04499@hot.jw.home обсуждение исходный текст |
Ответ на | using OID as primary key (Markus Wagner <wagner@imsd.uni-mainz.de>) |
Ответы |
Re: using OID as primary key
|
Список | pgsql-sql |
Markus Wagner wrote: > Hi, > > are there any disadvantages of using OID as the primary key for any > table? > What about referencing external tuples using their OIDs? > > e. g.: > CREATE TABLE thistable > ... > field NUMERIC REFERENCES OtherTable (oid) > > Which data type should I use to reference OIDs? > > Will I run into problems later if I do my things this way? Currently OID is not supported for references. Has to do with some checks done in the RI triggers, using SPI functions. We're thinking about a solution... Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #
В списке pgsql-sql по дате отправления: