Re: 9.5 Import foreign schema error with user defined type in schema other than public.

From: reiner peterke <zedaardv(at)drizzle(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Date: 2015-06-10 17:25:54
Message-ID: 9CEA6331-E9F8-4A1A-B594-11E50642BDE8@drizzle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


> On Jun 9, 2015, at 3:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 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

Ok i missed that

Thanks,

reiner

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message David Fetter 2015-06-10 19:03:52 Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Previous Message David G. Johnston 2015-06-10 17:13:24 Re: BUG #13426: table bloat - dead rows not removed after vacuum