From: | Tarlika Elisabeth Schmitz <postgresql6(at)numerixtechnology(dot)de> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | [PL/pgSQL] function call |
Date: | 2011-10-31 13:31:41 |
Message-ID: | 20111031133141.1da3c452@dick.coachhouse |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2011-10-31 13:52:28 | Re: Why is there no 8.3.16 rpm with _id ? |
Previous Message | Ondrej Ivanič | 2011-10-31 13:17:33 | Re: Regarding the shared disk fail over cluster configuration |