Stephan Szabo wrote:
>>> "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.
> Except that SQL92 at least does seem to say in 11.8 that "All rows that
> are marked for deletion are effectively deleted at the end of the
> SQL-statement, prior to the checking of any integrity constraints." I
> think that likely makes our behavior wrong, but I'm not really sure how to
> get there from what we have now.
Just for the record: it works on Oracle 8i (and I assume it works on
later versions) and SQL Server 2005.
PEM Platform Team Leader
Web Site: http://swsoft.com/
In response to
pgsql-bugs by date
|Next:||From: Heikki Linnakangas||Date: 2007-05-18 12:34:01|
|Subject: Re: BUG #3277: error occurs between different versions|
|Previous:||From: Christian Kratzer||Date: 2007-05-18 07:23:14|
|Subject: Re: strange problem with ip6 |