At 2:11 PM -0700 8/2/07, Mikey C wrote:
Does anyone know if there is a plan to implement the enforcement of the
SQL-92 FOREIGN KEY constraints?
Seems to me the No.1 missing feature. After all, data integrity, even in an
embedded DB is very important and bugs in client code can easily mess up the
referential integrity.
I believe that this is planned; however, some other planned upates
have higher priority and are being done first. Note also that
traditional foreign key constraints can only implement some kinds of
business rules, and there are lots of others whose violation could
cause problems, that foreign keys wouldn't help with; in theory, the
more generic format of triggers is a more complete solution, or more
specifically, free-form check constraints that can be comprised of
any query are a more complete solution. -- Darren Duncan
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
