Re: [Treebase-devel] study_id vs submission_id issues

[youjun g. <you...@ya...>]

Dear All,

Just for you info,

Based on the test results of Bill and I, when delete a group of
phylotreenode, it will not cause foreign key constrain violation, as long as
after deletion there is no broken foreign in finish state. This means that
deletion of a tree have to be  atomic.

In table phylotree, many trees do not have a study_id value, but their
phylotreenode related to study 22 via table taxonlabel.  Their phylotree_id
are:

1129,1130,1131,1132,     2333,2334,2335,2336,2337,2338,
2339,2340,2341,2343,2556,2557,2686,2726,2727,2787,2788,2789,2790,
3446,3671,3766,3767,3901,3902,3903,3904,3905,3906,3907,3908,3909,3910,3911,3912,
4062,4063,
5705,5706,5707,5708,5720,5721,5921,5941,5981,160000022341

I will delete those trees because their foreign key constrain  prevent me
from cleaning up about 10,000 dummy taxonlabel records related to submission
22 (study 22 and submission 22 happen to be the same).

Youjun