Skip site navigation (1) Skip section navigation (2)

BUG #6172: DROP EXTENSION error without CASCADE

From: "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6172: DROP EXTENSION error without CASCADE
Date: 2011-08-21 16:44:37
Message-ID: 201108211644.p7LGibJ1064013@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6172
Logged by:          Hitoshi Harada
Email address:      umi(dot)tanuki(at)gmail(dot)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.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-08-21 18:51:41
Subject: Re: Segfault with before triggers and after triggers with a WHEN clause.
Previous:From: Yoran HelingDate: 2011-08-21 12:00:55
Subject: Segfault with before triggers and after triggers with a WHEN clause.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group