Re: 7.1 LOCK TABLE changes

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: 7.1 LOCK TABLE changes
Дата
Msg-id Pine.LNX.4.30.0106052329550.900-100000@peter.localdomain
обсуждение исходный текст
Ответ на 7.1 LOCK TABLE changes  (Brian Powell <brian@owlscreech.com>)
Список pgsql-sql
Brian Powell writes:

> In our client app, we lock our table before doing something to it.
> Fortunately, in 7.0.3, a view looked like a table and we could perform:
>
> lock v_whatever in share row exclusive mode;

There is no and never was any point in locking a view, since it doesn't
contain any data.  Usually, you don't need explicit locks anyway, but I
can't tell from here why you might want to.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: query on two databases ..
Следующее
От: clayton cottingham
Дата:
Сообщение: plperl