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/