Re: Finer Extension dependencies

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Why do features have OIDs? Is this for pg_depend entries? If so, would
> it work to have pg_depend entries point to extensions instead?

Yes, for pg_depend, no I don't know how to make that work with pointing
to the extensions directly, because the whole point here is to be able
to depend on a feature rather than the whole extension.

Use cases:

- depend on a feature f that appeared in version y of the extension
(bugfix, new capability)

- deprecate a feature: alter extension update removes a feature, you
want to know that the dependent extensions need processing (cascade
to remove them in the operation, or update them before hand, etc)
(still manual operation though)

I don't see how to handle those cases with a direct dependency on the
extension rather than one of its features.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support