amorati <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
