Re: Possibility to disable `ALTER SYSTEM`

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Martín Marqués <martin.marques@gmail.com>, Isaac Morland <isaac.morland@gmail.com>, Magnus Hagander <magnus@hagander.net>, Gabriele Bartolini <gabriele.bartolini@enterprisedb.com>, pgsql-hackers@postgresql.org
Date: 2024-02-01T12:33:04Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Add allow_alter_system GUC.

  2. Rename COMPAT_OPTIONS_CLIENT to COMPAT_OPTIONS_OTHER.

  3. Remove support for version-0 calling conventions.

On Tue, Jan 30, 2024 at 04:25:12PM -0500, Robert Haas wrote:
> I don't think we should pretend like one of the two paragraphs above
> is valid and the other is hot garbage. That's not solving anything. We
> can't resolve the tension between those two things in either direction
> by somebody hammering on the side of the argument that they believe to
> be correct and ignoring the other one.

What if we generate log messages when certain commands are used, like
ALTER TABLE?  We could have GUC which controls which commands are
logged.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.