Can't move extension out of pg_catalog

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Can't move extension out of pg_catalog
Date: 2012-06-15 18:11:40
Message-ID: CA+mi_8bY6zfDc+HUufknuf0fogzseZatGyGQqE+UQ=4JLTX69A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

After moving an extension into the pg_catalog schema, it seems
impossible to move it somewhere else:

test=# create extension ltree;
CREATE EXTENSION
test=# alter extension ltree set schema pg_catalog;
ALTER EXTENSION
test=# alter extension ltree set schema public;
ERROR: cannot remove dependency on schema pg_catalog because it is a
system object.

It is still possible to drop it.

Tested with PostgreSQL 9.1.3.

-- Daniele

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-06-15 19:49:55 Re: Can't move extension out of pg_catalog
Previous Message Tom Lane 2012-06-15 16:35:25 Re: BUG #6690: ALL and ANY array operators