Hello all,
if I create a schema with a master table and various child tables and use the SERIAL type for the primay key of the master table and want to insure referential integrity in the child tables what data type is compatible with the SERIAL type.
It makes sense to me that I want a type other than SERIAL in the child tables as SERIAL would create a unique number for the children as well, correct?
I quess my first question should have been is SERIAL the equivelant of an auto increment field?
TIA
John
if I create a schema with a master table and various child tables and use the SERIAL type for the primay key of the master table and want to insure referential integrity in the child tables what data type is compatible with the SERIAL type.
It makes sense to me that I want a type other than SERIAL in the child tables as SERIAL would create a unique number for the children as well, correct?
I quess my first question should have been is SERIAL the equivelant of an auto increment field?
TIA
John