[GENERAL] OID and PK/FK KEYS

2004-10-20 Thread Raffaele Spizzuoco
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

Re: [GENERAL] OID and PK/FK KEYS

2004-10-20 Thread Kevin Barnard
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