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

From reiner peterke
Subject Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Date
Msg-id 9CEA6331-E9F8-4A1A-B594-11E50642BDE8@drizzle.com
Whole thread Raw
In response to Re: 9.5 Import foreign schema error with user defined type in schema other than public.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> On Jun 9, 2015, at 3:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> 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 to import the the =
foreign schema i got the following error.
>=20
> 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:
>=20
>     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.
>=20
> ("Same names" includes the schema name, btw.)
>=20
>             regards, tom lane

Ok i missed that

Thanks,

reiner=

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #13426: table bloat - dead rows not removed after vacuum
Next
From: David Fetter
Date:
Subject: Re: 9.5 Import foreign schema error with user defined type in schema other than public.