Re: [SQL] Avoiding RI failure with INSERT ... SELECT FROM

2006-07-12 Thread Aaron Bono
On 7/12/06, Mark Stosberg <[EMAIL PROTECTED]> wrote: Hello! I got an unexpected SQL failure last night, and want to see howto prevent it in the future. This is with 8.1.3.I have a couple of insert statements that run in a transaction block,initializing rows that will be used the next day: INSERT in

[SQL] Avoiding RI failure with INSERT ... SELECT FROM

2006-07-12 Thread Mark Stosberg
Hello! I got an unexpected SQL failure last night, and want to see how to prevent it in the future. This is with 8.1.3. I have a couple of insert statements that run in a transaction block, initializing rows that will be used the next day: INSERT into item_hit_log SELECT item_id, CURRENT_DAT