Primary Key on Inherited Table
| От | Wenjin Zheng |
|---|---|
| Тема | Primary Key on Inherited Table |
| Дата | |
| Msg-id | E3E65B3C4E12D311BE6900A0C9EC2FA11ACF8F@GENOMICS1 обсуждение исходный текст |
| Ответы |
Re: Primary Key on Inherited Table
|
| Список | 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.zheng@lsbc.com
В списке pgsql-hackers по дате отправления: