> As for what I think we *should* do near-term, I'm pretty strongly
> tempted to suggest that we just throw an error if a subtransaction
> to upgrade an upper transaction's shared lock to exclusive.

So when a RI check locks a parent, you would not be able to update the
in a later subtrans.
I can imagine, that the error would be a problem in a select for update
because there you usually want to update the row.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to