> >
> > Q : will this locking prevent update of the rows in TESTTABLE that have
> > been SELECTed ?
> >
>
> While the SELECT is running, no one can update the table. If the SELECT
> is in a transaction, no one can update the table until the transaction
> completes. Other people can read from the table, though.
Does only one transaction run at a time? That is, if you have a
transaction from client A that does a select followed by an update
and client B attempts the same thing, will the read portion of
B's transaction be deferred until A's commit completes, while
a non-transaction select (read only) from B would be allowed to
proceed?
Les Mikesell