Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations - Mailing list pgsql-bugs

Excerpts from Tom Lane's message of jue ago 30 23:19:12 -0400 2012:
> Bruce Momjian <bruce@momjian.us> writes:
> > On Fri, Jun 22, 2012 at 10:37:10PM -0400, Tom Lane wrote:
> >> jeff@pgexperts.com writes:
> >>> DROP and CREATE extension appear to work fine, but if you ALTER EXT=
ENSION
> >>> postgis SET SCHEMA foo, it leaves a few relations behind.
>=20
> >> What it seems to be leaving behind is indexes ... also relation rowt=
ypes.
>=20
> > Uh, did this get fixed?  I can't find a commit related to the fix.
>=20
> No, it's still an open issue.

Hmm, I think this might be my bug.  I will have a look at this; not sure
if I'll be able to do it tomorrow, though (and certainly not during the
weekend).

--=20
=C3=81lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services