Re: [SQL] reliable lock inside stored procedure (SOLVED)

"Robert Haas" <robertmhaas@gmail.com> writes:
>> That's a good point.  We throw error for DECLARE CURSOR outside a
>> transaction block, since it's obviously a mistake.  I wonder whether
>> we shouldn't equally throw error for LOCK outside a transaction block.
>> 
>> Objections anyone?

> No, I've been bitten by this myself.

OK, done in CVS HEAD.
        regards, tom lane