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

Thank you Jeff.
I'll create the index on the geometry column as gist instead of spgist. On my first impression it seems to work fine ;)
Cheers,
João Ferreira
On Tuesday, June 18, 2019, 01:22:27 PM GMT+1, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

On Tue, Jun 18, 2019 at 8:02 AM Joao Ferreira <jpgferreira(at)yahoo(dot)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