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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: Sebastian Böhm <psql(at)seb(dot)exse(dot)net>, "Richard Huxton" <dev(at)archonet(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [SQL] reliable lock inside stored procedure (SOLVED)
Date: 2008-11-04 00:57:59
Message-ID: 9997.1225760279@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

"Robert Haas" <robertmhaas(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2008-11-04 01:20:31 Re: [WIP] In-place upgrade
Previous Message Brendan Jurd 2008-11-04 00:35:36 Re: new correlation metric

Browse pgsql-sql by date

  From Date Subject
Next Message Bart van Houdt 2008-11-04 12:31:56 Display message to user
Previous Message Robert Haas 2008-11-04 00:26:47 Re: [SQL] reliable lock inside stored procedure (SOLVED)