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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
