http://stackoverflow.com/a/2681413 http://stackoverflow.com/a/2681413 SET CONSTRAINTS ALL DEFERRED Then do your inserts, followed by whatever work needs to be

http://stackoverflow.com/a/2681413 http://stackoverflow.com/a/2681413 SET CONSTRAINTS ALL DEFERRED Then do your inserts, followed by whatever work needs to be done without referential integrity, in the same transaction.