Primary key inheritance in Postgres
| From: | Bernie Huang | Date: | Fri, 16 Jun 2000 20:41:07 +0000 |
| Subject: | Primary key inheritance in Postgres | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-444@lists.php.net to get a copy of this message | ||
Hi,
I know this is not quite the right list to post but it's urgent. I have
posted this to postgres mailing-list, but no answer return, and am hoping
if anyone knows maybe he can help. Thanks!
Bernie Huang wrote:
> 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