lucas@presserv.org wrote:
> CREATE TRIGGER products_codes_checkfieldvalue BEFORE INSERT OR UPDATE ON
> main.products_codes FOR EACH ROW EXECUTE PROCEDURE
> trigger_system_checkfieldvalue('main','products_codes');
> ------- ERROR: function trigger_system_checkfieldvalue() does not exist
>
> But the function trigger_system_checkfieldvalue() EXIST! With (text,text)
> parameters.
> I can't built the trigger for this table (main.products_codes) using the check
> field in main_system.products_codes.
> What is wrong???
From the manuals:
Note that the function must be declared with no arguments even if it
expects to receive arguments specified in CREATE TRIGGER --- trigger
arguments are passed via TG_ARGV, as described below.
See pl/pgsql - trigger procedures for details.
-- Richard Huxton Archonet Ltd