From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Josué Maldonado <josue(at)lamundial(dot)hn> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Pass parameters to a TCL function |
Date: | 2003-09-04 19:32:37 |
Message-ID: | 3F579355.6030004@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume LELARGE | 2003-09-04 19:36:22 | Re: French translation |
Previous Message | Bjørn T Johansen | 2003-09-04 19:31:52 | Backup? |