Re: Cascade view drop permission checks

David, thank you for the clarification.

Should we consider raising log level for cascade drops from NOTICE to WARNING? By now cascade drops appears in log files only when log level >= NOTICE.

--- a/src/backend/catalog/dependency.c

+++ b/src/backend/catalog/dependency.c

@@ -1105,7 +1105,7 @@ reportDependentObjects(const ObjectAddresses *targetObjects,

                                           int flags,

                                           const ObjectAddress *origObject)

 {

- int msglevel = (flags & PERFORM_DELETION_QUIETLY) ? DEBUG2 : NOTICE;

+ int msglevel = (flags & PERFORM_DELETION_QUIETLY) ? DEBUG2 : WARNING;

        bool ok = true;

        StringInfoData clientdetail;

        StringInfoData logdetail;