Обсуждение: No promany key in parent table, how to use delete cascade?
Dear All, I want to dreate a delete cascade in children tables. The primary key of parent table is oid, so when I create parent table, there is no apparetly key word "primary key". The problem jumps out. When I create child table using columnn constraint on delete, the SQL says: "PRIMARY KEY for referenced table "parent" not found" I do not need to specify the primary key since I am using oid. How can I get around this problem? Thanks. Zhidian Du _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
On Thu, 7 Nov 2002, Zhidian Du wrote: > Dear All, > > I want to dreate a delete cascade in children tables. The primary key of > parent table is oid, so when I create parent table, there is no apparetly > key word "primary key". The problem jumps out. > > When I create child table using columnn constraint on delete, the SQL says: > > "PRIMARY KEY for referenced table "parent" not found" > > I do not need to specify the primary key since I am using oid. How can I > get around this problem? I'm not sure if 7.2 lets you make the constraint at all, but even if it does, you need a unique index on oid and you need to specify that the constraint is to oid (col references parent(oid))