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

From Jan Wieck
Subject Re: Pass parameters to a TCL function
Date
Msg-id 3F579355.6030004@Yahoo.com
Whole thread Raw
In response to Re: Pass parameters to a TCL function  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general

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 majordomo@postgresql.org)

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: TCL trigger doesn't work after deleting a column
Next
From: Bjørn T Johansen
Date:
Subject: Backup?