Re: [PATCH] Implement motd for PostgreSQL

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Implement motd for PostgreSQL
Date: 2021-04-04 06:23:56
Message-ID: 7d70b3d2-3a36-45f0-8753-96bf6397b972@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kazutaka Onishi 2021-04-04 06:30:23 Re: TRUNCATE on foreign table
Previous Message Joel Jacobson 2021-04-04 05:55:16 Re: [PATCH] Implement motd for PostgreSQL