alter function/procedure depends on extension

*Briefly* qu. 1. What is the use-case for "alter function/procedure depends on extension"? After all, subprograms depend, functionally, on all sorts of things. But (unlike in Oracle Database) there’s (almost) no semantic check at “create” time and therefore nothing like the semantics that ORCL’

Re: alter function/procedure depends on extension

> david.g.johns...@gmail.com wrote: > >> david.g.johns...@gmail.com wrote: >> >> …and the documentation for ALTER FUNCTION should read "…as dependent on an >> extension may be dropped when the extension is dropped". > > Nevermind this - if the extension is dropped the function will go away. Bu

Re: alter function/procedure depends on extension

> david.g.johns...@gmail.com wrote: > > 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 read, and re-re

<    1   2   3   4