Re: Programmatic Trigger Create

2021-03-20 Thread Tom Lane
Adrian Klaver writes: > In what program is: > EXEC SQL EXECUTE IMMEDIATE :my_sql_cmd > being done? Presumably ECPG, which if memory serves defaults to not-auto-commit. Maybe Niko is failing to commit the transaction? If all else fails, turning on log_statements on the server and examining the lo

Re: Programmatic Trigger Create

2021-03-20 Thread Adrian Klaver
On 3/20/21 10:03 AM, Niko Ware wrote: I would like to programmatically create audit trail functions which are called by triggers for custom user tables. This will be used for audit trail generation in our application. The user is able to define a custom table. Therefore, I need a custom audit t

Programmatic Trigger Create

2021-03-20 Thread Niko Ware
I would like to programmatically create audit trail functions which are called by triggers for custom user tables. This will be used for audit trail generation in our application. The user is able to define a custom table. Therefore, I need a custom audit trail function. The audit trail function ou