Re: Trigger with parameters

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