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

From Tom Lane
Subject Re: trigger parameters, what am I doing wrong ??
Date
Msg-id 22071.1223572936@sss.pgh.pa.us
Whole thread Raw
In response to trigger parameters, what am I doing wrong ??  ("Marcin Krawczyk" <jankes.mk@gmail.com>)
Responses Re: trigger parameters, what am I doing wrong ??  ("Bart Degryse" <Bart.Degryse@indicator.be>)
List pgsql-sql
"Marcin Krawczyk" <jankes.mk@gmail.com> 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;
NOTICE:  TG_ARGV = 42, TG_NARGS = 1, par = 42
UPDATE 1

You need to show a more complete example of what you're doing.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: sequence number in a result
Next
From: "Relyea, Mike"
Date:
Subject: Re: sequence number in a result