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

Поиск
Список
Период
Сортировка
От reiner peterke
Тема Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Дата
Msg-id 9CEA6331-E9F8-4A1A-B594-11E50642BDE8@drizzle.com
обсуждение исходный текст
Ответ на Re: 9.5 Import foreign schema error with user defined type in schema other than public.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #13426: table bloat - dead rows not removed after vacuum
Следующее
От: David Fetter
Дата:
Сообщение: Re: 9.5 Import foreign schema error with user defined type in schema other than public.