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

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [SQL] reliable lock inside stored procedure (SOLVED)
Дата
Msg-id 603c8f070811031626o62bdb84dw1f44b083eaea1a38@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] reliable lock inside stored procedure (SOLVED)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [SQL] reliable lock inside stored procedure (SOLVED)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Vladimir Sitnikov"
Дата:
Сообщение: Re: Bitmap Indexes patch (was Re: Bitmap Indexes: request for feedback)
Следующее
От: "Brendan Jurd"
Дата:
Сообщение: Re: Grant proposal