table protein does not have an attribute oid? why?

Поиск
Список
Период
Сортировка
От Zhidian Du
Тема table protein does not have an attribute oid? why?
Дата
Msg-id F140GdMNFmWAFsTmICl00000575@hotmail.com
обсуждение исходный текст
Список pgsql-sql


Dear All:



I want to create a delete cascade in children tables.  The primary key of 
parent table is oid.




CREATE TABLE Link (   Protein_ID oid,   Link varchar(128)   CONSTRAINT one   REFERENCES Protein (oid)   ON DELETE
CASCADE
);

Create child table is ok.

When I insert a record into this child table, it says
"ERROR: constraint one: table protein does not have an attribute oid"

Why?


Thanks.



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail



В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Time difference without intervals
Следующее
От: "Zhidian Du"
Дата:
Сообщение: Parent table has not oid?