Primary Key on Inherited Table

From: Wenjin Zheng <wenjin(dot)zheng(at)lsbc(dot)com>
To: "Pgsql-Hackers (E-mail)" <pgsql-hackers(at)postgresql(dot)org>
Subject: Primary Key on Inherited Table
Date: 2000-05-09 19:00:50
Message-ID: E3E65B3C4E12D311BE6900A0C9EC2FA11ACF8F@GENOMICS1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I was trying to create a table that inherites from a parent table. I have
to use the fields both from the parent table and the child table to define
the primary key. Unfortunately I was not able to do that. It can not find
the fields from the parent table and give me the error "column .. does not
exist". I can not specify the fields by using parenttable.column either. I
have read the documentations and there is nothing in the inheritance chapter
talking about primary key. Is there a way to specify primary key in the
child table using columns from parent table? I am using 6.5.0. Helps will
be greatly appreciated.

Wenjin Zheng
Bioinformatic Analyst
Large Scale Biology
3333 Vaca Valley Parkway
Vacaville, CA 95688
(707)469-2353
email: wenjin(dot)zheng(at)lsbc(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert B. Easter 2000-05-09 20:38:02 Re: [HACKERS] inheritance and primary and foreign keys
Previous Message Jeff MacDonald 2000-05-09 18:53:43 misc questions