Re: drop view not possible to select from pg_view

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: drop view not possible to select from pg_view
Дата
Msg-id 22789.1043443271@sss.pgh.pa.us
обсуждение исходный текст
Ответ на drop view not possible to select from pg_view  ("frank_lupo" <frank_lupo@email.it>)
Список pgsql-general
"=?utf-8?Q?frank=5Flupo?=" <frank_lupo@email.it> writes:
> When drop view and i do not send commit or rollback is not possible to sele=
> ct from other user on pg_view. The selection is lock. =0D

The only thing that's locked is computing the "definition" field for the
view you are currently altering (read dropping).  I see no way to avoid
that, nor any really strong reason to worry about it.  Access to a table
that you're currently dropping is locked, too.

            regards, tom lane

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

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: More PHP DB abstraction layer stuff
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Searchable 7.3.1 Documentation - now interactive!