Re: Problems during doing reindex on 7.0.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems during doing reindex on 7.0.3
Дата
Msg-id 25427.974171051@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problems during doing reindex on 7.0.3  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Список pgsql-general
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Denis Perchine wrote:
>> ERROR:  Index 2050642 does not exist
>>
>> Looks like index oid was already resolved, but index was not locked yet...
>> And it was dropped just under the feet...

> Parser-rewriter-planner acquires a short term lock.
> This may be improved in 7.1 though I'm not sure.

I believe it is fixed for 7.1 --- a lock is acquired at first
reference to the table and not released.

            regards, tom lane

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

Предыдущее
От: Alvar Freude
Дата:
Сообщение: Array-Handling: use in subselect, push ...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Is this proper UNION behavior??