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

From: David Fetter <david(at)fetter(dot)org>
To: reiner peterke <zedaardv(at)drizzle(dot)com>
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 19:03:52
Message-ID: 20150610190352.GA30879@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jamie Koceniak 2015-06-10 21:39:45 Re: BUG #13426: table bloat - dead rows not removed after vacuum
Previous Message reiner peterke 2015-06-10 17:25:54 Re: 9.5 Import foreign schema error with user defined type in schema other than public.