Re: [QUESTIONS] Re: [HACKERS] Re: locking

> >
> >  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