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
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 |