Re: Endless For Loop in an insert trigger

Luis Agostinho wrote:
> Hello
> I?m using this function to be executed within an after insert trigger, but
> the part of code above wich is "painted" by blue gets in an endless loop.
> I could use some help

Luis - not sure what you mean by "painted by blue", but there are some
basic steps I always use when debugging triggers:
  1. Put RAISE NOTICE messages throughout the code
  2. Turn statement logging on in my postgresql.conf

Note that you must do:
   RAISE NOTICE ''My var = % which is nice'', my_var;
and _not_
   RAISE NOTICE ''My var = '' || my_var || '' which is nice'';

--
   Richard Huxton
   Archonet Ltd