Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing

Поиск
Список
Период
Сортировка
От feichanghong
Тема Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing
Дата
Msg-id tencent_0970A420002AA9BDFB648077027C309B840A@qq.com
обсуждение исходный текст
Ответ на Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing
Список 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.

Вложения

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)
Следующее
От: "feichanghong"
Дата:
Сообщение: Re: "ERROR: could not open relation with OID 16391" error was encountered when reindexing