[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

What is a "deferred" violation?



Hi folks,

This is probably a dumb question, but can someone explain this error to me:

com.mckoi.database.jdbc.MSQLException: Deferred foreign key constraint
violation (RefOutgoing_mail35) Columns = APP.Unsent_recipient( item_id ) ->
APP.Outgoing_mail( item_id )

Does this mean that it is trying to add a record into Unsent_recipient whose
item_id value does not match any record in the Outgoing_mail table? What is
the significance of the term 'deferred' there?

TIA.

=====
------
M. A. Sridhar
m_a_sridhar@yahoo.com

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/