inheritance and primary key - Mailing list pgsql-sql

From Bernie Huang
Subject inheritance and primary key
Date
Msg-id 3947F3A9.12BDF72@ec.gc.ca
Whole thread Raw
List pgsql-sql
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

Attachment

pgsql-sql by date:

Previous
From: "Brian C. Doyle"
Date:
Subject: Outputting the Tables of a database
Next
From: Vadim Passynkov
Date:
Subject: Some problem with inet type on PostgreSQL-7.0