From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
---|---|
To: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | foreign key validation error message |
Date: | 2004-11-01 14:38:19 |
Message-ID: | 1099319899.2640.8.camel@dicaprio.akademie1.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
I just got the following on 7.4:
oocms=# delete from objects where object_id = 3993;
ERROR: update or delete on "objects" violates foreign key constraint "$1" on "object_as_xml"
DETAIL: Key (object_id)=(3993) is still referenced from table "object_as_xml".
So, there you go:
oocms=# delete from object_as_xml where object_id = 3993;
ERROR: связь "object_as_xml" не существует
(relation "object_as_xml" does not exist)
object_as_xml is in a schema that's not in the search path. The error
message for the foreign key violation should include the schema of the
involved relation.
--
Markus Bertheau <twanger(at)bluetwanger(dot)de>
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-11-01 15:00:01 | Re: possible bug using combination of 'serial' and rule |
Previous Message | Silvio Scarpati | 2004-11-01 13:34:11 | Re: minor issue in createdb 8.0.0beta4 |