Subject Re: [firebird-support] Re: Pessimistic locking
Author Aage Johansen
On Wed, 24 Sep 2003 19:46:58 +0000 (UTC), hay77772000 wrote:

> A question though - if I add a record to a table, along with multiple
> associated records in tables with foreign keys, do I need to do any kind
> of locking?
> ...

I don't think so. Other users won't even see the inserted records until
you commit. The commit will enable other users to see all the records, but
they may have to start a new transaction (depending on their 'transaction
isolation' setting).

Aage J.