John Belli wrote: > What is the recommended conflict to raise during an FK enforcement > trigger? I'm not asking about how to create the triggers, I've figured > that part out; I just want to know which conflict should be used. I > think I'm asking, which do other db systems tend to use? > > > JAB
Hi John, I'm not sure there is a "standard" answer. The "right" answer probably depends on the needs of the application and whether it is robsut enough to deal with various situations that might occur that would trigger a conflict. For example: 1) under what conditions might a conflict occur? 2) does the application code doing the insert have a recovery if it fails. 3) is the application communicating back to a real user that can decide how to handle the situation? 4) is this an automated process that needs to work or fail leaving the DB unchanged on failure? 5) etc -Steve _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
