Trigger/Rules Order of operations

I am interested in finding out the pros, cons, pitfalls of using the
following design:

Manual insert into Table A.
Table A has a BEFORE INSERT trigger that causes an insert to table B.
Table B has an AFTER INSERT trigger that causes an insert back to
table A (With different criteria not an endless loop)

Table A will have its Before Trig fire again and this time the
criteria causes it to finish with a return new.

Will the second insert into table A commit before the first insert
into table A? What order does the insert into table B finish up?

Ketema J. Harris
www.ketema.net
ketema(at)ketema(dot)net
ketemaj on iChat