> long running transactions can be evil. is there a reason why this has > to run in a single transaction? This single transaction is used to import new information in a database. I need it because the database cannot be disconected from the users, and the whole new data has to be consistently. There are different constraints that are checked during the import.
