Re: Extension tracking temp table and causing update failure - Mailing list pgsql-bugs

From Phil Sorber
Subject Re: Extension tracking temp table and causing update failure
Date
Msg-id CADAkt-i81KSUC2-dsTnN8A3x7BMHNCCvSBpjtY0NJcAw0Woksg@mail.gmail.com
Whole thread Raw
In response to Re: Extension tracking temp table and causing update failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Tue, Mar 6, 2012 at 5:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Instead, I'm tempted to propose that dependency.c explicitly allow drops
> of objects that belong to the current extension, when an extension is
> being created or updated. =A0(That is, if we come across a dependency
> reference to the active extension, we just ignore it. =A0A quick look
> suggests that this would require only a very small patch.) =A0That would
> prevent the entire class of problems.
>
> It would also have the effect that explicit DROPs of member objects in
> extension scripts could be done without an explicit ALTER EXTENSION DROP
> first. =A0I think we'd originally decided that requiring the ALTER was a
> good safety feature, but is it really more than nanny-ism? =A0The intent
> of a DROP command seems pretty clear.
>
> Thoughts?

I know you were more looking for Dimitri's answer to this, but I like the i=
dea.

pgsql-bugs by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD
Next
From: Sergey Burladyan
Date:
Subject: Re: BUG #6480: NLS text width problem