"Christian Nassau" <[EMAIL PROTECTED]> wrote:
> I would guess that your requests acquire (shared) read locks when the
> transaction starts and then fail/deadlock when they try to upgrade this
> to a write lock in your insert/update statement. Maybe it would help to
> start the transactions with "BEGIN IMMEDIATE" or "BEGIN EXCLUSIVE"...?
>
In TCL, you can do this as:
db transaction immediate {
# code here
}
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
