Re: bug or feature?

On Fri, 6 Dec 2002, [Windows-1251] wrote:

> Hello there
> have some problems on 7.2.3/freebsd
>
> ex.
> table1 has 2 columns: id and name
> table2 has 3 columns: id, t1_id(references t1(id) on delete cascade) and
> 'name' field
>
> i got a procedure (plpgsql)
>
> declare i int;
> begin
> select count(*) into i from table2 where t1_id=123;
> raise notice ''rows selected: %'',i;
> delete from table1 where id=123;
> select count(*) into i from table2 where t1_id=123;
> raise notice ''rows selected: %'',i;
> end;
>
> the constraint trigger on delete executes ONLY after procedure
> completion, but it does not execute right after delete. WHY?

It's considered to run at the end of statement (where the statement
in question is the statement that calls the plpgsql function). There's
been arguments about the timing of the referential actions, but I believe
this is currently the expected behavior.