Re: [PATCH] Implement motd for PostgreSQL

Поиск
Список
Период
Сортировка
От Joel Jacobson
Тема Re: [PATCH] Implement motd for PostgreSQL
Дата
Msg-id 7d70b3d2-3a36-45f0-8753-96bf6397b972@www.fastmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Implement motd for PostgreSQL  ("Joel Jacobson" <joel@compiler.org>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Joel Jacobson"
Дата:
Сообщение: Re: [PATCH] Implement motd for PostgreSQL
Следующее
От: Kazutaka Onishi
Дата:
Сообщение: Re: TRUNCATE on foreign table