Re: [GENERAL] Pass parameters to a TCL function

2003-09-04 Thread Jan Wieck
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

Re: [GENERAL] Pass parameters to a TCL function

2003-09-02 Thread Josué Maldonado
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

[GENERAL] Pass parameters to a TCL function

2003-09-02 Thread Josué Maldonado
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