| Is there value in testing deferrable constraints? [message #158614] |
Mon, 13 February 2006 08:33  |
brightgarden
Messages: 2
Registered: February 2006
|
Junior Member |
|
|
Hello.
I don't know where to post this question. Feel free to move the discussion.
In a nutshell, we have two applications accessing the database (VB and Java). None of our constraints are deferrable. The database was designed in 8i, but we've since migrated to 9i (and on our way to 10g). I want to make a few foreign key constraints deferrable to deal with a design catch-22.
I have looked and looked for any caveats, problems, issues related to using deferrable constraints on a multi-user/multi-application database, and can't find anything that addresses this.
I'm inclined to think that testing our applications for this deferrable constraint is about the same as testing to make sure the non-null constraints function as expected--something we really just trust the database to do properly.
So, is there value in testing deferrable constraints? Is there a chance that our legacy applications will screw up because of them? It seems so unlikely.
Thanks.
- Maggie
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
