Pass parameters to a TCL function - Mailing list pgsql-general

From Josué Maldonado
Subject Pass parameters to a TCL function
Date
Msg-id bj2rod$2ge2$1@news.hub.org
Whole thread Raw
Responses Re: Pass parameters to a TCL function  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Field collection in trigger
Next
From: Josué Maldonado
Date:
Subject: how to call a TCL function from within a plpgsql trigger?