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>
Re: Problems during doing reindex on 7.0.3 Denis Perchine <dyp@perchine.com>
Re: Problems during doing reindex on 7.0.3 Tom Lane <tgl@sss.pgh.pa.us>
Hiroshi Inoue  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
Дата:
От: Tom Lane
Дата:
FAQ