"Martin Crundall" <pgsql(at)ac6rm(dot)net> writes:
> Some of the data tables have "AFTER INSERT" TRIGGERs on them that, in
> turn, insert some subordinate items into parallel data tables and the
> central pointer/ordering table.
It looks to me like AFTER triggers are fired upon return to the main
loop in postgres.c, thus only at the end of a querystring sent by the
client. This is perhaps wrong, but I'm not sure that allowing them to
fire during plpgsql functions would be a good thing either.
regards, tom lane