> The deferred foreign key checks are exactly > what I needed. They are quite useful for other reasons > too.
I believe Postgres is just following standards. Yes, deferred is very useful for other things, like a real data model layer mediating between UI and database--without it you have to worry about performing inserts (and updates) in a particular order. That can be really painful to code, and in some cases (cyclic relationships) impossible to do except by leaving some constraints out. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 665-7007 voice ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend