cannot move relocatable extension out of pg_catalog schema

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: cannot move relocatable extension out of pg_catalog schema
Date: 2013-02-01 20:08:58
Message-ID: 510C20DA.2010208@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

create extension hstore with schema pg_catalog;
alter extension hstore set schema public;
ERROR: 0A000: cannot remove dependency on schema pg_catalog because it
is a system object
drop extension hstore; -- works

I've seen this happen cleaning up after mistakenly misplaced extensions.
I suspect this is a bug.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2013-02-01 20:21:52 Re: cannot move relocatable extension out of pg_catalog schema
Previous Message Robert Haas 2013-02-01 20:07:31 Re: sql_drop Event Trigger