Re: Trigger changes visibility

amorati <antonio.cosas@terra.es> writes:
> CREATE OR REPLACE FUNCTION "public"."DisparadorHijoBorradoCMin1" ()
> RETURNS trigger AS
> ...
> LANGUAGE 'plpgsql' IMMUTABLE CALLED ON NULL INPUT SECURITY INVOKER;

> The problem is that the row's count done by the trigger is the same
> number of rows that appears in the table before de delete was executed.

Don't use an IMMUTABLE function as a trigger.  I'm not sure if the
system should actually prohibit this, but the function is doing what
it's spec'd to, namely not seeing any side-effects of the calling query.
See
http://developer.postgresql.org/docs/postgres/xfunc-volatility.html

            regards, tom lane