BUG #6172: DROP EXTENSION error without CASCADE - Mailing list pgsql-bugs

From Hitoshi Harada
Subject BUG #6172: DROP EXTENSION error without CASCADE
Date
Msg-id 201108211644.p7LGibJ1064013@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6172: DROP EXTENSION error without CASCADE
List pgsql-bugs
The following bug has been logged online:

Bug reference:      6172
Logged by:          Hitoshi Harada
Email address:      umi.tanuki@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.

pgsql-bugs by date:

Previous
From: Yoran Heling
Date:
Subject: Segfault with before triggers and after triggers with a WHEN clause.
Next
From: Tom Lane
Date:
Subject: Re: Segfault with before triggers and after triggers with a WHEN clause.