Re: Question: what is proper way to define python function asevent_trigger?

Jeff, hi:

1. my concern is global "event_trigger" for DDL, not per-table "trigger" 
for DML

2. regardless - thank you for the link, I found it helpful

3. Tom Lane says event_trigger is just not implemented in plpython

Andrei.

On 2019-12-22 17:20, Jeff Ross wrote:
> On 2019-12-22 16:07, Jeff Ross wrote:
>> On 2019-12-22 15:27, Andrei Pozolotin wrote:
>>> 
>>> Hello.
>>> 
>>> Problem:
>>> 
>>> 1. any attempt to define python function as an event_trigger, i.e.:
>>> 
>>> CREATE FUNCTION public.verify()
>>> RETURNS event_trigger
>>> LANGUAGE 'plpython3u'
>>> AS $$ print("hello-kitty") $$;
>>> 
>>> 2. fails with message:
>>> 
>>> ERROR: trigger functions can only be called as triggers
>>> 
>>> SQL state: 0A000
>>> 
>>> 3. here in the source:
>>> 
>>> https://github.com/postgres/postgres/blob/master/src/pl/plpython/plpy_procedure.c#L226 
>>> Question:
>>> 
>>> what is proper way to define python function as event_trigger?
>>> 
>>> Thank you.
>>> 
>>> 
>> Just do
>> 
>> "create function public.verify() as trigger..."
>> 
> My bad--that should be "create function public.verify() returns 
> trigger... "
> 
> Jeff