Re: [Treebase-devel] Deleting Childless treeblocks

[Hilmar L. <hl...@ne...>]

I agree, deleting the study should work. Did you submit it as a bug  
report?

-hilmar

Sent from away

On Jan 8, 2010, at 1:28 PM, William Piel <wil...@ya...> wrote:

>
> On Jan 8, 2010, at 12:30 PM, Hilmar Lapp wrote:
>
>> two questions first: 1) Do you still have the original data file  
>> that would clearly prove that these treeblocks must be spurious?
>
> The 4,000+ orphaned treeblocks belong to study_id 22 which is not  
> published, lacks a citation, and is owned by user "tb1" (which is  
> for testing). Don't know how it acquired all these records. So no, I  
> don't have any "original" data file, but then there is nothing  
> original about this artifact.
>
>> and 2) why would we not delete only the spurious treeblocks and  
>> sub_treeblocks, rather than the entire study?00
>
> It seemed easier to me to click once (delete study_id 22) rather  
> than making 4,000+ mouse clicks to delete the treeblocks.
>
>> Note that your join below won't work the way I think you intend it  
>> to work
>
> thanks -- I'll check it over. It seemed to work (in that doing a  
> count(treeblock_id) produced the correct number of records).
>
> bp
>
>
>
>
> --- 
> --- 
> --- 
> ---------------------------------------------------------------------
> This SF.Net email is sponsored by the Verizon Developer Community
> Take advantage of Verizon's best-in-class app development support
> A streamlined, 14 day to market process makes app distribution fast  
> and easy
> Join now and get one step closer to millions of Verizon customers
> http://p.sf.net/sfu/verizon-dev2dev
> _______________________________________________
> Treebase-devel mailing list
> Tre...@li...
> https://lists.sourceforge.net/lists/listinfo/treebase-devel