Re: [GENERAL] Pass parameters to a TCL function

[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 
Tcl list $args and $1-$n.

Jan

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
  AFTER INSERT OR UPDATE OR DELETE
  ON xtable
  FOR EACH ROW
  EXECUTE PROCEDURE audit_log('xtable','internal');
it gives this error:

ERROR:  CreateTrigger: function audit_log() does not exist

I also tried to make a kinda wrapper plpgsql trigger to call the 
audit_log function but didn't work, any idea what's wrong?, how do I 
pass parameters to a trigger function?

Thanks in advance,

Josue Maldonado.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match