Which record causes referential integrity violation on delete
От | Andrus |
---|---|
Тема | Which record causes referential integrity violation on delete |
Дата | |
Msg-id | da43e6$26sl$2@news.hub.org обсуждение исходный текст |
Ответы |
Re: Which record causes referential integrity violation on delete
Re: Which record causes referential integrity violation on delete Re: Which record causes referential integrity violation on delete Re: Which record causes referential integrity violation on delete |
Список | pgsql-general |
In Postgres 8 I tried commad DELETE FROM customer WHERE id=123 but got an error ERROR: update or delete on "customer" violates foreign key constraint "invoice_customer_fkey" on "invoice"' How to determine the primary key of invoice table which causes this error in generic way ? Why Postgres does not report primary key value in error message ? I it is not possible to add more information to error I need function which takes 3 arguments: table name ('customer') field name ('id') field value (123) and returns the name of the table and primary key value which blocks record deletion. I looked to the ODBC log, but this does'nt contain more information about error !? Andrus.
В списке pgsql-general по дате отправления: