Re: [BUGS] Trigger changes visibility

2005-01-17 Thread Tom Lane
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 a

[BUGS] Trigger changes visibility

2005-01-17 Thread amorati
Hello, I'm having an unexpected behaviour when executing an 'after delete' trigger. In PostgreSQL 8.0.0beta5 documentation, section 33.2 "Visibility of Data Changes", it is said that "When a row-level after trigger is fired, all data changes made by the outer command are already complete, and are