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
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 |