Re: Checking for FK constraints only after the transaction commited ????

2004-06-04 Thread Jochem van Dieten
Leandro Melo wrote: So, is there a way to only check for the FKs constraint at the end of the transaction, and not at the rigth moment of the insert Not in MySQL. Other databases have functionality named deferred constraints, where constraint checking is deferred to transaction commit, but My

Re: Checking for FK constraints only after the transaction commited ????

2004-06-04 Thread Josh Trutwin
On Fri, 4 Jun 2004 09:39:44 -0300 (ART) Leandro Melo <[EMAIL PROTECTED]> wrote: > Hi, > i`m using mysql in a j2ee application with JBoss. > For best design practices i cannot add the > foreign-keys to the tables in the same "insert" as i > add the table data. Basically, i`ll add it a few > millise

Checking for FK constraints only after the transaction commited ????

2004-06-04 Thread Leandro Melo
Hi, i`m using mysql in a j2ee application with JBoss. For best design practices i cannot add the foreign-keys to the tables in the same "insert" as i add the table data. Basically, i`ll add it a few milliseconds latter (in the same transaction), but anyway it`s not in the same "insert". Then, i ha