On Thu, Mar 17, 2005 at 08:48:54AM +, Spencer Riddering wrote:
> When a LOCK TABLE statement is included in a plpgsql function it does not
> actually lock the table.
How did you determine that? It's not clear from the example you
posted, and your function has its LOCK statements commented o
"Spencer Riddering" <[EMAIL PROTECTED]> writes:
> When a LOCK TABLE statement is included in a plpgsql function it does not
> actually lock the table.
Sure it does. If it doesn't, your test case surely will not prove it;
you cannot prove the existence or lack of existence of a lock in a test
cas
The following bug has been logged online:
Bug reference: 1550
Logged by: Spencer Riddering
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Debian Woody ( Postgresql from backports.org)
Description:LOCK TABLE in plpgsql function doesn't wor