Re: Question: what is proper way to define python function as event_trigger?
Andrei Pozolotin <[email protected]> Sun, 22 Dec 2019 20:53:20 -0600
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
Tom, hi: 1. actual use case has to do with: BUG #16177: pg_event_trigger_ddl_commands() returns empty set for ddl_command_start and "drop table" https://www.postgresql.org/message-id/16177-053a34714817c3e1%40postgresql.org 2. I was merely hoping to re-implement pg_event_trigger_ddl_commands as part of python event_trigger 3. do you think "pg_event_trigger_ddl_commands" is any easier to fix then "support event_trigger in python"? Thank you, Andrei On 2019-12-22 17:40, Tom Lane wrote: > Andrei Pozolotin <[email protected]> writes: >> 1. any attempt to define python function as an event_trigger, i.e.: > > AFAICS, there's not really any event trigger support in plpython. > That feature has only been built out in the other three PLs. > > Somebody oughta fix this sometime, I guess, but it evidently hasn't > been high priority. If you feel like working on it, you could look > at commits e5dc4cc24d2e1e94ac572a2c64103710bf15d21e (for plperl) > and/or a5036ca998a6058f60913d43a80badfcbb65f5bb (for pltcl). > > regards, tom lane