The install script sets SET LOCAL client_min_messages = WARNING near the top of the extension SQL.
Because SET LOCAL is transaction-scoped and CREATE EXTENSION runs in a single transaction, this overrides whatever the caller had set — for the entire CREATE EXTENSION (including any CASCADE that pulls this extension in as a dependency).
Impact: a caller who deliberately sets a stricter level (e.g. SET client_min_messages = error to keep install output quiet) is silently overridden, so messages emitted during install still print and cannot be suppressed by the caller.
Suggestion: inspect the current value before changing it rather than blindly forcing WARNING — e.g. only lower verbosity when the caller hasn't already set a stricter level, or save the prior value and restore it at the end.
🤖 (Filed by Claude at @jnasbyupgrade's request)
The install script sets
SET LOCAL client_min_messages = WARNINGnear the top of the extension SQL.Because
SET LOCALis transaction-scoped andCREATE EXTENSIONruns in a single transaction, this overrides whatever the caller had set — for the entireCREATE EXTENSION(including anyCASCADEthat pulls this extension in as a dependency).Impact: a caller who deliberately sets a stricter level (e.g.
SET client_min_messages = errorto keep install output quiet) is silently overridden, so messages emitted during install still print and cannot be suppressed by the caller.Suggestion: inspect the current value before changing it rather than blindly forcing
WARNING— e.g. only lower verbosity when the caller hasn't already set a stricter level, or save the prior value and restore it at the end.🤖 (Filed by Claude at @jnasbyupgrade's request)