Re: LOCK for non-tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: LOCK for non-tables
Дата
Msg-id 10862.1295037975@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: LOCK for non-tables  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: LOCK for non-tables  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Fri, 2011-01-14 at 15:05 -0500, Tom Lane wrote:
>> No, that will not work at all.  LOCK has to be a utility command.

> But it doesn't break the use case for locking sequences, ISTM.

You haven't stated what you think that use case is, but in any case
I'm sure someone can come up with another one where not freezing
the transaction snapshot *is* a consideration.

> Anyway, any suggestion that randomly breaks user applications is not
> good. If there is a good reason to do that, OK, but I don't see that
> here. 

The good reason is adding functionality.  Or is it your position that
the functionality under discussion is not worth any syntax breakage,
no matter how narrowly circumscribed?  If we take that position then
we can drop this whole thread, because nothing's going to happen.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Database file copy
Следующее
От: Marti Raudsepp
Дата:
Сообщение: Re: [PATCH] Return command tag 'REPLACE X' for CREATE OR REPLACE statements.