reiner peterke <zedaardv(at)drizzle(dot)com> writes:
> I was testing the import foreign schema feature in 9.5. i have a schema with a defined type timerange. When i tried to import the the foreign schema i got the following error.
I don't see any reason to think this isn't operating as designed.
postgres_fdw does not attempt to import user-defined data types from the
remote server. Per the manual:
If the remote tables to be imported have columns of user-defined
data types, the local server must have compatible types of the
same names.
("Same names" includes the schema name, btw.)
regards, tom lane