On Wed, Aug 23, 2006 at 12:48:53 -0700, Don Morrison <donmorrison(at)gmail(dot)com> wrote: > > My problem: if the insert fails because the value already exists, then > this starts a rollback of my entire transaction. The solution I'm
If you know there won't be concurrent inserts or deletes affecting the row of interest there is a way to do this in the INSERT statement.
> transaction...I'm not sure the nested transaction is necessary...maybe > just the savepoint. Example:
Using save points creates nested transactions, so you have that overhead by whatever name it is called.