Horton

Re: [PATCH] Implement motd for PostgreSQL

Joel Jacobson <joel@compiler.org>

View thread
From: "Joel Jacobson" <joel@compiler.org>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-04-04T06:23:56Z
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. Disallow newlines in parameter values to be set in ALTER SYSTEM.

On Sun, Apr 4, 2021, at 07:55, Joel Jacobson wrote:
> On Sat, Apr 3, 2021, at 17:50, Fabien COELHO wrote:
>> I'm wondering whether it should be possible to designate (1) a file the 
>> content of which would be shown, or (2) a command, the output of which 
>> would be shown [ok, there might be security implications on this one].
> 
> Can't we just do that via plpgsql and EXECUTE somehow?

Right, we can't since

ERROR:  ALTER SYSTEM cannot be executed from a function

I wrongly thought a PROCEDURE would work, but it gives the same error.

/Joel