"David G. Johnston" <david.g.johns...@gmail.com> writes:
> On Thu, Feb 17, 2022 at 6:17 PM Tom Lane <t...@sss.pgh.pa.us> wrote:
>> There is no bug here; it's operating as designed and documented.
>> Maybe the docs need some refinement.

> We should just say that ALTER FUNCTION ALTER DEPENDS ON makes the target
> function/procedure a (transient?) member of the extension and it will be
> dropped when the extension be dropped.

It's not a member though; there's a different syntax for that
(ALTER EXTENSION name ADD member_object).  The differences are
a bit subtle, but for example making the function an extension
member would change how pg_dump treats it.

I confess not remembering exactly why we thought the auto-drop
behavior was important enough to deserve special infrastructure.
Still, it's there now, and the question of dependencies that the
dependency system can't see is really quite a different thing.

                        regards, tom lane


Reply via email to