Re: 9.5 Import foreign schema error with user defined type in schema other than public. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Date
Msg-id 29891.1433857720@sss.pgh.pa.us
Whole thread Raw
In response to 9.5 Import foreign schema error with user defined type in schema other than public.  (reiner peterke <zedaardv@drizzle.com>)
Responses Re: 9.5 Import foreign schema error with user defined type in schema other than public.
List pgsql-bugs
reiner peterke <zedaardv@drizzle.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
toimport 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

pgsql-bugs by date:

Previous
From: nnd@go.com
Date:
Subject: BUG #13419: could not adopt C locale
Next
From: Tom Lane
Date:
Subject: Re: BUG #13420: Array function contains with null