On Sun, May 09, 2004 at 12:13:31PM +0800, Christopher Kings-Lynne wrote:
> >I intend to release locks on subtransaction abort, so if the update
> >fails there's room for another transaction to insert the key (which I
> >understand should fail?). I guess there's a different locking mechanism
> >needed; I believe nested transactions will not be enough.
>
> Except you can keep trying and trying without the outermost transaction
> failing.
But that won't provide the necessary next key locking you mentioned in
your first email, will it?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No necesitamos banderas
No reconocemos fronteras" (Jorge González)
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
