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
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
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