The following bug has been logged online:

Bug reference:      6172
Logged by:          Hitoshi Harada
Email address:      umi.tan...@gmail.com
PostgreSQL version: 9.1RC1
Operating system:   Windows7
Description:        DROP EXTENSION error without CASCADE
Details: 

On pure-installed RC1 database, you can CREATE EXTENSION, but cannot DROP
it.

CREATE EXTENSION cube;
DROP EXTENSION cube;

ERROR:  cannot drop extension cube because other objects depend on it
DETAIL:  operator <>(cube,cube) depends on function cube_ne(cube,cube)
operator >(cube,cube) depends on function cube_gt(cube,cube)
operator <=(cube,cube) depends on function cube_le(cube,cube)
operator >=(cube,cube) depends on function cube_ge(cube,cube)
operator <@(cube,cube) depends on function cube_contained(cube,cube)
operator ~(cube,cube) depends on function cube_contained(cube,cube)
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

DROP EXTENSION ... CASCADE; works but without CASCADE should work as source
build on Linux does it.

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to