Re: Possibility to disable `ALTER SYSTEM` - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Possibility to disable `ALTER SYSTEM`
Date
Msg-id 202309091514.fdjfxlr5kjrw@alvherre.pgsql
Whole thread Raw
In response to Re: Possibility to disable `ALTER SYSTEM`  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Possibility to disable `ALTER SYSTEM`
List pgsql-hackers
On 2023-Sep-08, Magnus Hagander wrote:

> Now, it might be that you don't care at all about the *security* side
> of the feature, and only care about the convenience side. But in that
> case, the original suggestion from Tom of using an even trigger seems
> like a fine enough solution?

ALTER SYSTEM, like all system-wide commands, does not trigger event
triggers.  These are per-database only.

https://www.postgresql.org/docs/16/event-trigger-matrix.html

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"If it is not right, do not do it.
If it is not true, do not say it." (Marcus Aurelius, Meditations)



pgsql-hackers by date:

Previous
From: Vik Fearing
Date:
Subject: Re: Row pattern recognition
Next
From: Tom Lane
Date:
Subject: Re: BUG #18097: Immutable expression not allowed in generated at