On Sun, Jun 19, 2005 at 09:58:11AM -0600, Michael Fuhr wrote: > > If possible, it would be best to commit transactions that insert > or update foreign keys as soon as possible.
I probably shouldn't have said "best" here, implying that this solution is better than all other possibilities. As Tom Lane pointed out, you could also make the constraints deferrable. If you don't need to know about foreign key violations immediately, then deferring the checks might be a better way to go. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
