Postgres Pro
Downloads
Home   >   mailing lists

Re: ON DELETE CASCADE with multiple paths - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ON DELETE CASCADE with multiple paths
Date
Msg-id 25725.1179413415@sss.pgh.pa.us
Whole thread Raw
In response to ON DELETE CASCADE with multiple paths  (Max Khon <mkhon@swsoft.com>)
Responses Re: ON DELETE CASCADE with multiple paths  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Tree view 
Max Khon <mkhon@swsoft.com> writes:
> "delete from foo" fails:

> ERROR: update or delete on table "bar" violates foreign key constraint
> "foobar_fk0" on table "foobar"
> SQL state: 23503
> Detail: Key (bar_id)=(1) is still referenced from table "foobar".
> Context: SQL statement "DELETE FROM ONLY "public"."bar" WHERE "foo_id" = $1"

I see no bug here.  There is no guarantee about the order in which
constraints are applied.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Max Khon
Date:
Subject: ON DELETE CASCADE with multiple paths
Next
From: Andrew Sullivan
Date:
Subject: Re: strange problem with ip6