greg@antrez.pl writes:
> Is it ok that we loose referential integrity by locking DELETE on table
> test_item ?
Yes. If you put a trigger on a table involved in an FK constraint, it's
your responsibility that the trigger doesn't break FK update operations.
regards, tom lane