Re: trigger parameters, what am I doing wrong ??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: trigger parameters, what am I doing wrong ??
Date: 2008-10-09 17:22:16
Message-ID: 22071.1223572936@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Midgley 2008-10-09 19:16:02 Re: many-to-many relationship
Previous Message Tom Lane 2008-10-09 17:14:24 Re: sequence number in a result