Re: How to ensure data consistency?

Either I'm misunderstanding you completely, or what you are trying to do requires the ability to defer constraint checking until COMMIT time.

If you can defer the constraints, then your do the insert to the main table and the inserts to the corresponding secondary table in the same transaction. By the time you do the COMMIT, everything is OK.

If your constraints are always evaluated at the time of an action, you're in CATCH-22. Received on Wed Sep 08 2004 - 13:26:35 CDT