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