Re: ON DELETE CASCADE with multiple paths

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