Re: [sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

2008-10-16 Thread John Belli
On Tue, 14 Oct 2008 22:10:12 +0700, Dan <[EMAIL PROTECTED]> wrote: >ABORT seems right to me. Causes the current statement to have no >effect, but does not rollback the current transaction. On Tue, 14 Oct 2008 11:16:17 -0500, Stephen Woodbridge <[EMAIL PROTECTED]> wrote: >I'm not sure there is a

Re: [sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

2008-10-14 Thread Stephen Woodbridge
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? > > > JA

Re: [sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

2008-10-14 Thread Dan
On Oct 14, 2008, at 1:07 AM, 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

[sqlite] Foreign Key Triggers: ABORT, FAIL, or ROLLBACK

2008-10-14 Thread John Belli
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 -- John A. Belli Software Eng