"Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at> writes:
> So when a RI check locks a parent, you would not be able to update the
> parent in a later subtrans. I can imagine, that the error would be a
> problem in a select for update loop, because there you usually want to
> update the row.
No, it would not, because select for update would acquire exclusive lock
in the first place.
regards, tom lane