Re: How to ensure data consistency?
From: Marshall Spight <mspight_at_dnai.com>
Date: Thu, 09 Sep 2004 02:16:32 GMT
Message-ID: <42P%c.150624$Fg5.121300_at_attbi_s53>
Date: Thu, 09 Sep 2004 02:16:32 GMT
Message-ID: <42P%c.150624$Fg5.121300_at_attbi_s53>
"Laconic2" <laconic2_at_comcast.net> wrote in message news:ap-dndW9qNif0qLcRVn-uQ_at_comcast.com...
> 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.
Marshall Received on Thu Sep 09 2004 - 04:16:32 CEST