Re: [HACKERS] Possible TODO: allow arbitrary expressions in event trigger WHEN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Possible TODO: allow arbitrary expressions in event trigger WHEN
Дата
Msg-id 11467.1487043275@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] Possible TODO: allow arbitrary expressions in event trigger WHEN  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: [HACKERS] Possible TODO: allow arbitrary expressions in eventtrigger WHEN  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Re: [HACKERS] Possible TODO: allow arbitrary expressions in eventtrigger WHEN  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Jim Nasby <Jim.Nasby@BlueTreble.com> writes:
> Is there a reason not to allow $SUBJECT? Specifically, it'd be nice to 
> be able to do something like WHEN tag LIKE 'ALTER%'.

Seems like it would be a seriously bad idea for such an expression to be
able to invoke arbitrary SQL code.  What if it calls a user-defined
function that tries to do DDL?
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] possibility to specify template database for pg_regress
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion