On Mon, Mar 21, 2016 at 7:19 AM, Abhijit Menon-Sen <ams@2ndquadrant.com> wrote:
> At 2016-03-21 13:04:33 +0300, a.korotkov@postgrespro.ru wrote:
>>
>> I'm not sure why we want to make new dependency type by ALTER FUNCTION
>> command, not ALTER EXTENSION?
>
> It's a matter of semantics. It means something very different than what
> an 'e' dependency means. The extension doesn't own the function (and so
> pg_dump shouldn't ignore it), but the function depends on the extension
> (and so dropping the extension should drop it).
Yeah, I think this is definitely an ALTER FUNCTION kind of thing, not
an ALTER EXTENSION kind of thing.
I also think we should allow a function to depend on multiple
extensions, as Alvaro mentions downthread.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company