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 по дате отправления: