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 had to configure my foreign-keys to be allow null, something that i really don`t want to do. 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???? Thanks, ===== beginner ______________________________________________________________________ Participe da pesquisa global sobre o Yahoo! Mail: http://br.surveys.yahoo.com/global_mail_survey_br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]