This happens on 9.4.1 and HEAD. The variant extension is locked to a specific schema by it's control file: decibel@decina:[23:53]~/git/variant (master %=)$cat variant.control # variant extension comment = 'Variant data type for PostgreSQL' default_version = '1.0.0-beta3' relocatable = false schema = 'variant'
CREATE EXTENSION creates the variant schema for me, but it leaves it behind when I drop the extension. I assume this is a bug and not by design?
[email protected]=# \dn List of schemas Name | Owner --------+--------- public | decibel (1 row) [email protected]=# BEGIN; BEGIN [email protected]=#* CREATE EXTENSION variant; CREATE EXTENSION [email protected]=#* \dn List of schemas Name | Owner ----------+--------- _variant | decibel public | decibel variant | decibel (3 rows) [email protected]=#* DROP EXTENSION variant; DROP EXTENSION [email protected]=#* \dn List of schemas Name | Owner ---------+--------- public | decibel variant | decibel (2 rows) [email protected]=#* DROP SCHEMA variant ; DROP SCHEMA [email protected]=#* \q -- Jim Nasby, Data Architect, Blue Treble Consulting Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
