On Sunday, July 27, 2025, Sadeq Dousti <msdou...@gmail.com> wrote: > > (a) The patch affects DROP EXTENSION in that it drops the schema as well, > if it's owned by the extension. This needs to be mentioned in the > documentation. In addition, an extra confirmation (e.g., "This will drop > schema nnnn as well, do you wish to continue?") when dropping the > extension might be desired, as the extension schema could contain user > data (e.g., pg_cron keeps the jobs and their execution details). >
SQL isn’t interactive in this sense. There isn’t a way to ask “are you sure?”. At best the server can refuse to do something unless additional options, like “force/cascade” are present in the command. David J.
