Hi guys. I'm trying to pass a parameter to trigger procedure but it's not
working and I have no idea why since it looks pretty ok. Here's what I do :
CREATE OR REPLACE FUNCTION test_proc()
RETURNS "trigger" AS
$BODY$
DECLARE
chk boolean;
par integer := TG_ARGV[0];
BEGIN
RAISE NOTICE 'TG_ARGV = %, TG_NARGS = %, par = %', TG_ARGV[0], TG_NARGS,
par;
-- [...] some computations
RETURN NEW;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
CREATE TRIGGER jks_test_proc_tg
AFTER UPDATE
ON test_table
FOR EACH ROW
EXECUTE PROCEDURE test_proc(42);
And here's what RAISE NOTICE looks like : NOTICE: TG_ARGV = <NULL>,
TG_NARGS = 0, par = <NULL>
What's wrong with it ?? I'm running 8.1.4
regards
mk