Hi,

when I want to delete a record, which is used in another table, and
there is an on delete restrict constraint on it, I get a constraint
error.
This tells the user, that this record is used somewhere in another
table, but not in which record of the other table.
Is there any simple way to find out at least one (the first) record,
which causes the constraint error, to show the user which record he
should inspect to look for the reason of the error message.
I know, that there could be much more records, and it would be great
the get a solution to get every single record, which causes a
constraint error, but it also would be great to get at least one.

Any suggestions?

cu
Helmut