Josué Maldonado wrote:
I'm sorry, found my mistake, the way I'm calling the function is wrong
it should be "audit_log" ('xtable','internal'), it works.
Hmmm, that should not work. The function should be declared taking no
arguments and you yet find the arguments from the CREATE TRIGGER in the
I'm sorry, found my mistake, the way I'm calling the function is wrong
it should be "audit_log" ('xtable','internal'), it works.
Thanks
Josué Maldonado wrote:
Hello list,
I have a tcl trigger function called audit_log(varchar, bpchar), if I
write a trigger in a table
CREATE TRIGGER tg_test
Hello list,
I have a tcl trigger function called audit_log(varchar, bpchar), if I
write a trigger in a table
CREATE TRIGGER tg_test
AFTER INSERT OR UPDATE OR DELETE
ON xtable
FOR EACH ROW
EXECUTE PROCEDURE audit_log('xtable','internal');
it gives this error:
ERROR: CreateTrigger: funct