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

Поиск
Список
Период
Сортировка
От Andrei Pozolotin
Тема Question: what is proper way to define python function asevent_trigger?
Дата
Msg-id 0d6c5bdc3ab532bc3240cfb14bc55ce9@gmail.com
обсуждение исходный текст
Ответы Re: Question: what is proper way to define python function asevent_trigger?  (Jeff Ross <jross@openvistas.net>)
Re: Question: what is proper way to define python function as event_trigger?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

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.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Semi-unable to add new records to table--primary key needed?
Следующее
От: Jeff Ross
Дата:
Сообщение: Re: Question: what is proper way to define python function asevent_trigger?