Re: [SQL] reliable lock inside stored procedure (SOLVED) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [SQL] reliable lock inside stored procedure (SOLVED)
Date
Msg-id 603c8f070811031626o62bdb84dw1f44b083eaea1a38@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] reliable lock inside stored procedure (SOLVED)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] reliable lock inside stored procedure (SOLVED)
List pgsql-hackers
> 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.
>
> I can sort of imagine some corner cases where
> lock-and-immediately-release would be the intended behavior, but that
> sure seems a whole lot less probable than it being user error.
> And you could always throw BEGIN/COMMIT into the command if that
> really was what you wanted.
>
> Objections anyone?

No, I've been bitten by this myself.

...Robert


pgsql-hackers by date:

Previous
From: "Vladimir Sitnikov"
Date:
Subject: Re: Bitmap Indexes patch (was Re: Bitmap Indexes: request for feedback)
Next
From: "Brendan Jurd"
Date:
Subject: Re: Grant proposal