Re: Problems during doing reindex on 7.0.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Problems during doing reindex on 7.0.3
Date
Msg-id 25427.974171051@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problems during doing reindex on 7.0.3  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List 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 by date:

Previous
From: Alvar Freude
Date:
Subject: Array-Handling: use in subselect, push ...
Next
From: Tom Lane
Date:
Subject: Re: Is this proper UNION behavior??