Re: [SQL] Trigger with parameters

2005-03-21 Thread Richard Huxton
[EMAIL PROTECTED] 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 functio

[SQL] Trigger with parameters

2005-03-18 Thread lucas
Hi, I am building a generic database in postgresql. And I am having a lot of problem Yes, I am just studing and learning about postgres. Lets go: My database have two schemas: 1 - The MAIN schema 2 - The System schema. I created the system schema that contains the table_fields register for th