Thread: No promany key in parent table, how to use delete cascade?

No promany key in parent table, how to use delete cascade?

From
"Zhidian Du"
Date:
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



Re: No promany key in parent table, how to use delete cascade?

From
Stephan Szabo
Date:
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))