Postgres Pro
Downloads
Home   >   mailing lists

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

From David Fetter
Subject Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Date
Msg-id 20150610190352.GA30879@fetter.org
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>)
List pgsql-bugs
Tree view 
On Tue, Jun 09, 2015 at 10:56:26AM +0200, reiner peterke wrote:
> Hi,
>
> 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 ran into this with PostGIS, and what I did to solve it is install
PostGIS on the local node.

Perhaps starting with importing your dba schema, or recursively down
to whichever one is "root" in the sense of the dependency graph could
help.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-bugs by date:

Previous
From: reiner peterke
Date:
Subject: Re: 9.5 Import foreign schema error with user defined type in schema other than public.
Next
From: Jamie Koceniak
Date:
Subject: Re: BUG #13426: table bloat - dead rows not removed after vacuum