Mark Morgan Lloyd wrote:
>
> If I might ask a related question- assuming that a client has grabbed a
> restrictive lock during a transaction that e.g. is create/replacing functions,
> what happens to other sessions that attempt to run a select or update- will they
> fail (i.e. an implicit NOWAIT) or will they wait until the lock is released?
> Does this vary depending on whether a select/update is within an explicit
> transaction?
They will wait without an explicit NOWAIT. This applies whether the
transaction is explicit or implicit.
--
Richard Huxton
Archonet Ltd
