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

Поиск
Список
Период
Сортировка
От Bart Degryse
Тема Re: trigger parameters, what am I doing wrong ??
Дата
Msg-id 48EF1AF8.A3DD.0030.0@indicator.be
обсуждение исходный текст
Ответ на Re: trigger parameters, what am I doing wrong ??  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@sss.pgh.pa.us> 2008-10-09 19:22 >>>
"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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

В списке pgsql-sql по дате отправления:

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: many-to-many relationship
Следующее
От: "Sabin Coanda"
Дата:
Сообщение: Re: 100% CPU at concurent access