INSERT WITH "NOWAIT"

Could you please help us with the follow problem.

Table A has two keys.
Field pk is a primary key and uk is a unique key.

A session inserts into A the record (pk_vall, uk_vall) successfully. The session does not commit the insertion. Another session does attempts to insert the same record and because there is
the uncommitted previously inserted record from another session has to wait until
the first session execute a commit or a row back 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 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 solution)

Thank you very much

Nicholas Economou Received on Thu May 07 1998 - 06:14:39 CDT