"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> Why can't we keep all locks until main tx end ?
For committed subtransactions we have to do that, yes, but for aborted
subtransactions we must release. Otherwise you can't implement a retry
loop around a potentially-deadlocking operation.
> (I am assuming that a deadlock will still break the whole tx)
Wrong. We might as well not bother with the entire project.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
