With some version (but I don't remember which) I had the same problem.
I solved it by assigning TG_ARGV[0] to a variable and use the variable in the
RAISE NOTICE.
Tom Lane [EMAIL PROTECTED] 2008-10-09 19:22
Marcin Krawczyk [EMAIL PROTECTED] writes:
And here's what RAISE NOTICE looks like :
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;
parinteger := TG_ARGV[0];
BEGIN
RAISE NOTICE
Marcin Krawczyk [EMAIL PROTECTED] writes:
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
Works for me:
regression=# insert into test_table values(1);
INSERT 0 1
regression=# update test_table set f1 = 2;