Opened 5 years ago

Closed 5 years ago

#4440 closed defect (fixed)

Type Lookups in FDW fail

Reported by: pramsey Owned by: pramsey
Priority: critical Milestone: PostGIS 2.5.3
Component: postgis Version: 2.5.x -- EOL
Keywords: Cc:

Description

​https://dba.stackexchange.com/questions/240718/querying-foreign-table-with-sp-gist-index-results-in-error-cache-lookup-failed?rq=1

Because FDW connections have very sparse search_path, it's common for calls to TypenameGetTypid() to fail. A different way of looking up the PostGIS type Oid numbers needs to be used.

Change History (3)

comment:1 by pramsey, 5 years ago

In 17567:

Type lookups in FDW fail due to sparse search_path.
References #4440

comment:2 by pramsey, 5 years ago

In 17568:

Internal type lookups fail over FDW
References #4440

comment:3 by pramsey, 5 years ago

Resolution: → fixed
Status: assigned → closed

In 17569:

Internal type lookups fail over FDW
Closes #4440

Note: See TracTickets for help on using tickets.