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
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
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