Insert with "nowait" - workaround.

Please help us on the following problem

Table A has two fields. Field pk is a primary key and field uk is a unique key.
A session inserts into A the record (pk_val1, uk_val1) successfully. The session does not commit the insertion. Another session attempts to insert the same record and because there is the uncommitted previously inserted record from another session the second session has to wait until the first session execute a commit or a rollback releasing the row-lock.

We want to change the above scenario. What we want is to make each session attempting to insert a record to be able to understand that at the specific moment a row-lock for the specific row exists and abort the insertion immediately.

We may say that we need a 'NOWAIT' behavior for the insert operation.

Which is the best method we can accomplish what we need? (We are looking for a work-around).

Thank you very much.
Nicolas Economou Received on Mon Apr 27 1998 - 00:00:00 CDT