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 <[EMAIL PROTECTED]> 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
