On 1/9/19 10:21 AM, github kran wrote:
Thanks for your reply Rob. Reading the below documentation link says
the EVENT trigger is only supported for DDL commands. Is it not correct ?.
_1) https://www.postgresql.org/docs/9.6/event-trigger-definition.html _
(An event trigger fires whenever the event with which it is associated
occurs in the database in which it is defined. Currently, the only
supported events are ddl_command_start, ddl_command_end,
table_rewrite and sql_drop. Support for additional events may be added
in future releases.).
2) Doesnt the trigger slow down inserts/update we are doing to the
table ?. Does it slow down if we are reading the data using the API
when we have a trigger in place ?.
Ah, right you are. Are triggers off the table? You would want to write
the trigger function in some (trusted?) language with access to the outside