] Understanding of LOCK and pg_sleep interaction
"David Johnston" writes:
> In trying to setup a test for a LOCK 'table' algorithm I attempt to
> execute two transactions where the first one issues a pg_sleep(10)
> while 'table' is locked and the second one attemp
"David Johnston" writes:
> In trying to setup a test for a LOCK 'table' algorithm I attempt to execute
> two transactions where the first one issues a pg_sleep(10) while 'table' is
> locked and the second one attempts LOCK 'table' during the time when the
> pg_sleep is executing. When pg_sleep()
Hi,
In trying to setup a test for a LOCK 'table' algorithm I attempt to execute
two transactions where the first one issues a pg_sleep(10) while 'table' is
locked and the second one attempts LOCK 'table' during the time when the
pg_sleep is executing. When pg_sleep() returns in the first trans
