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

Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: jeff(at)pgexperts(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Date: 2012-08-31 03:19:12
Message-ID: 27716.1346383152@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> On Fri, Jun 22, 2012 at 10:37:10PM -0400, Tom Lane wrote:
>> jeff(at)pgexperts(dot)com writes:
>>> DROP and CREATE extension appear to work fine, but if you ALTER EXTENSION
>>> postgis SET SCHEMA foo, it leaves a few relations behind.

>> What it seems to be leaving behind is indexes ... also relation rowtypes.

> Uh, did this get fixed?  I can't find a commit related to the fix.

No, it's still an open issue.

			regards, tom lane


In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2012-08-31 04:47:54
Subject: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Previous:From: Peter GeogheganDate: 2012-08-30 23:28:29
Subject: Re: Segmentation Fault V 9.1.5

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