trigger parameters, what am I doing wrong ?? - Mailing list pgsql-sql

From Marcin Krawczyk
Subject trigger parameters, what am I doing wrong ??
Date
Msg-id 95f6bf9b0810090011w12b9d97p76bc81f5106e028f@mail.gmail.com
Whole thread Raw
Responses Re: trigger parameters, what am I doing wrong ??
List pgsql-sql
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

pgsql-sql by date:

Previous
From: "Dirk Jagdmann"
Date:
Subject: Re: Insert a space between each character
Next
From: "Sabin Coanda"
Date:
Subject: Re: 100% CPU at concurent access