From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Extensions versus pg_upgrade |
Date: | 2011-02-09 03:25:30 |
Message-ID: | 1000.1297221930@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Tue, Feb 8, 2011 at 9:48 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Like ALTER THING SET SCHEMA, ALTER THING SET EXTENSION is implicitly
>> assuming that there can be only one owning extension for an object.
> I would assume that we would enforce that constraint anyway. No?
> Otherwise when you drop one of the two extensions, what happens to the
> object? Seems necessary for sanity.
Not sure --- what about nested extensions, for instance? Or you could
think about objects that are shared between two extensions, and go away
only if all those extensions are dropped. (RPM has exactly that
behavior for files owned by multiple packages, to take a handy example.)
My point is that the current restriction to just one containing
extension seems to me to be an implementation restriction, rather than
something inherent in the concept of extensions. I have no intention of
trying to relax that restriction in the near future --- I'm just
pointing out that it could become an interesting thing to do.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-02-09 03:28:22 | Re: Extensions versus pg_upgrade |
Previous Message | Hitoshi Harada | 2011-02-09 03:22:38 | Re: REVIEW: PL/Python table functions |