Skip site navigation (1) Skip section navigation (2)

BUG?! primary key in inherited table

From: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
To: PGSQL-BUGS <pgsql-bugs(at)postgresql(dot)org>
Subject: BUG?! primary key in inherited table
Date: 2000-06-15 17:14:24
Message-ID: 39490EF0.A5BC712F@ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-bugs
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: bernie.huang.vcf
Description: text/x-vcard (315 bytes)

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-06-15 19:12:34
Subject: Re: [unixODBC-DEV] - Re: [HACKERS] info on unixODBC/Postgres driver port to IRIX 6.5.7 64bit
Previous:From: Lamar OwenDate: 2000-06-15 16:27:30
Subject: Re: [unixODBC-DEV] - Re: [HACKERS] info on unixODBC/Postgres driver port to IRIX 6.5.7 64bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group