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@xxxxxxxxxx
ketemaj on iChat
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
