Re: [BUGS] BUG #1550: LOCK TABLE in plpgsql function doesn't work.

2005-03-17 Thread Michael Fuhr
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

Re: [BUGS] BUG #1550: LOCK TABLE in plpgsql function doesn't work.

2005-03-17 Thread Tom Lane
"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