cannot move relocatable extension out of pg_catalog schema - Mailing list pgsql-hackers

From Peter Eisentraut
Subject cannot move relocatable extension out of pg_catalog schema
Date
Msg-id 510C20DA.2010208@gmx.net
Whole thread Raw
Responses Re: cannot move relocatable extension out of pg_catalog schema  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: sql_drop Event Trigger
Next
From: Tom Lane
Date:
Subject: Re: cannot move relocatable extension out of pg_catalog schema