Re: [SQL] trigger firing order

2007-06-15 Thread chester c young
> > does the post trigger on A wait until post trigger on B is > executed? -> > this seems intuitive to me. > > How can it wait until the trigger on B is executed if the trigger on > B doesn't > actually get triggered until someone updates B and it's the trigger > on A > doing the update? trigge

Re: [SQL] trigger firing order

2007-06-15 Thread Gregory Stark
"chester c young" <[EMAIL PROTECTED]> writes: > tables A and B: a post row trigger on A cause updates on B which has > its own post row trigger. > > does the post trigger on A wait until post trigger on B is executed? - > this seems intuitive to me. How can it wait until the trigger on B is execu

[SQL] trigger firing order

2007-06-15 Thread chester c young
tables A and B: a post row trigger on A cause updates on B which has its own post row trigger. does the post trigger on A wait until post trigger on B is executed? - this seems intuitive to me. does the post trigger on B wait until the trigger on A has completed? or is post trigger A launched as

Re: [SQL] Organization of tables

2007-06-15 Thread operationsengineer1
Hi Salman, will this achieve your needs? peptide_table primary_key name (ie, Peptide1, Peptide2) mass fragment_table primary_key name (ie, A, Q, K) link_table primary_key peptide_id fragment_id it gives you easy access to peptide mass and it allows you to link multiple fragm