Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing - Mailing list pgsql-hackers

From feichanghong
Subject Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing
Date
Msg-id tencent_0970A420002AA9BDFB648077027C309B840A@qq.com
Whole thread Raw
In response to Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing  (Michael Paquier <michael@paquier.xyz>)
Responses Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing
List pgsql-hackers

For this specific job, I have always wanted a try_index_open() that
would attempt to open the index with a relkind check, perhaps we could
introduce one and reuse it here?

Yes, replacing index_open with try_index_open solves the problem. The
idea is similar to my initial report of "after successfully opening the heap
table in reindex_index, check again whether the index still exists”.
But it should be better to introduce try_index_open.


Best Regards,
Fei Changhong
Alibaba Cloud Computing Ltd.

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)
Next
From: "feichanghong"
Date:
Subject: Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing