| From: | Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca> |
|---|---|
| To: | PGSQL-SQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | inheritance and primary key |
| Date: | 2000-06-14 21:05:45 |
| Message-ID: | 3947F3A9.12BDF72@ec.gc.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| bernie.huang.vcf | text/x-vcard | 315 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex | 2000-06-15 06:55:15 | Re: Simple search question |
| Previous Message | Brian C. Doyle | 2000-06-14 19:47:23 | Outputting the Tables of a database |