On Mon, Nov 05, 2007 at 01:52:54PM -0400, Kynn Jones wrote: > BTW, I realize that I can just drop and reinstate constraints, but > from the point of view of writing a Perl script to do all this, it > would be much easier if I could just disable temporarily all the FK > constraints on a table. Do you really want to disable the foreign key constraint, or just defer their checking till you commit the transaction? If you just want to defer checking, then [1] may help. Sam [1] http://www.postgresql.org/docs/current/static/sql-set-constraints.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
