Re: [SQL] using OID as primary key

Thus spake Jan Wieck > > are there any disadvantages of using OID as the primary key for any > > table? > > What about referencing external tuples using their OIDs? > > Currently OID is not supported for references. Has to do with > some checks done in the RI triggers, using SPI funct

Re: [SQL] using OID as primary key

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

[SQL] using OID as primary key

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