"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Feb 17, 2022 at 6:17 PM Tom Lane <tgl@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