Pass parameters to a TCL function

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: Pass parameters to a TCL function
Date: 2003-09-02 19:40:59
Message-ID: bj2rod$2ge2$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josué Maldonado 2003-09-02 19:54:55 Re: Pass parameters to a TCL function
Previous Message Jenny - 2003-09-02 18:56:42 Re: identifying each individual tuple locked