| 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: | Whole Thread | Raw Message | 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 |