Horton

Re: Bug on drop extension dependencies ?

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2025-07-13T14:24:36Z
Lists: pgsql-hackers 
Em sáb., 12 de jul. de 2025 às 16:07, Tom Lane <tgl@sss.pgh.pa.us> escreveu:

> Indeed.  If we put a restriction on this case then we'd just need to
> invent a "REALLY CASCADE" option that did the more aggressive thing.
>

I understand that it's not possible to prevent DROP ... CASCADE from
executing. However, the subsequent deletion of constraints, triggers, or
functions will affect the behavior of other schemas, so I think it's
reasonable to at least explicitly state in the log which objects were
deleted due to that command.

regards
Marcos