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
