From: | "Bart Degryse" <Bart(dot)Degryse(at)indicator(dot)be> |
---|---|
To: | "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: trigger parameters, what am I doing wrong ?? |
Date: | 2008-10-10 07:06:00 |
Message-ID: | 48EF1AF8.A3DD.0030.0@indicator.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> 2008-10-09 19:22 >>>
"Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni Ruuhimäki | 2008-10-10 10:56:11 | SELECT multiple MAX(id)s ? |
Previous Message | Steve Midgley | 2008-10-09 19:16:02 | Re: many-to-many relationship |