BUG?! primary key in inherited table
Bernie Huang <bernie.huang@ec.gc.ca>
From: Bernie Huang <bernie.huang@ec.gc.ca>
To: PGSQL-BUGS <pgsql-bugs@postgresql.org>
Date: 2000-06-15T17:14:24Z
Lists: pgsql-bugs
Attachments
- bernie.huang.vcf (text/x-vcard)
Hi, Is primary key similar to 'not null columns with indices'? The reason I am asking because I found that when you inherit table B from table A, the primary key in A won't be inherited to B, but only the columns. I was wondering how do you inherit a primary key or, even, a foreign key? If it's not possible, what are the ways going around it? (not null index or...???) Thanks for your help! - Bernie