[PL/pgSQL] function call
От | Tarlika Elisabeth Schmitz |
---|---|
Тема | [PL/pgSQL] function call |
Дата | |
Msg-id | 20111031133141.1da3c452@dick.coachhouse обсуждение исходный текст |
Ответы |
Re: [PL/pgSQL] function call
|
Список | pgsql-general |
I have created a function log_insert(), which is simply a shorthand for an INSERT table and which I want to call from various trigger functions. CREATE OR REPLACE FUNCTION log_insert(vseverity text, vtrigger text, vtriggertable text, vtriggerid text, vmessage text) RETURNS boolean AS $BODY$ BEGIN INSERT INTO log (severity, trigger,triggertable, triggerid, message) VALUES (vseverity, vtrigger,vtriggertable, vtriggerid, vmessage); END $BODY$ LANGUAGE plpgsql VOLATILE; I tried: log_insert('I', TG_NAME, TG_TABLE_NAME, NEW.id, 'some msg'); => I get a syntax error on CREATE TRIGGER. SELECT log_insert(...) => passes the syntax check but throws an error when run: "function log_insert(unknown, unknown, unknown, integer, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts." Any help would be greatly appreciated. -- Best Regards, Tarlika Elisabeth Schmitz
В списке pgsql-general по дате отправления: