Re: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”
Дата
Msg-id CAMkU=1xocCv5rASP6+GAk3KyhQ-CrzoezQ-vb8p6UuHnX6k38Q@mail.gmail.com
обсуждение исходный текст
Ответ на Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”  (Joao Ferreira <jpgferreira@yahoo.com>)
Ответы Re: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”  (Joao Ferreira <jpgferreira@yahoo.com>)
Re: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jun 18, 2019 at 8:02 AM Joao Ferreira <jpgferreira@yahoo.com> wrote:
Greetings,

I'm using PostgreSQL 11.3 and I want to access a table in another Postgres database using postgres_fdw but since the original table has an SP-GiST index on a geometry column, the query on the foreign table fails with "ERROR: cache lookup failed for type 0", even if the table is empty (Step 7). This doesn't happen if the query is done directly to the remote table (Steps 3 and 6) or if the remote table doesn't have the index (Steps 3 and 4).

I've verified this on ubuntu 18.04 with 11.3 installed from PGDG apt repo, and attached a single-file reproduction.

If I change from sp-gist to just gist, there is no problem.  And if I change to indexing a built-in sp-gist operator class (point rather than geom), there is also no problem.

Getting postgis to compile is a bit hard and slow, so I haven't completed any tests against the unreleased versions yet.
 
Cheers,

Jeff
Вложения

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

Предыдущее
От: Joao Ferreira
Дата:
Сообщение: Querying foreign table with SP-GiST index results in “ERROR: cache lookup failed for type 0”
Следующее
От: Jorge Gustavo Rocha
Дата:
Сообщение: Re: BUG #15827: Unable to connect on Windows using pg_services.conf using Python psycopg2