Max Khon <mkhon(at)swsoft(dot)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