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

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

2005-03-17 Thread Spencer Riddering
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