Can't move extension out of pg_catalog - Mailing list pgsql-bugs

From Daniele Varrazzo
Subject Can't move extension out of pg_catalog
Date
Msg-id CA+mi_8bY6zfDc+HUufknuf0fogzseZatGyGQqE+UQ=4JLTX69A@mail.gmail.com
Whole thread Raw
Responses Re: Can't move extension out of pg_catalog
List 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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6690: ALL and ANY array operators
Next
From: Tom Lane
Date:
Subject: Re: Can't move extension out of pg_catalog