[Biojava-l] Re: [BioSQL-l] _removeSequence

[Simon Foote]

Hi Martina,

That would be correct as the on delete cascade doesn't touch the term 
tables as they are always referenced by any sequence.  There aren't any 
foreign key constraints put on those 4 tables, hence they don't get deleted.

Simon

Martina wrote:

> Hi,
>
> so I have this new database (still biosqldb-mysql.sqlv 1.40 2004/11/04 
> 01:49:41) and after removing all sequences, I do still have entries in 
> term, term_relationship,term_relationship_term and ontology. And of 
> course, in biodatabase. If I delete the entry in biodatabase too, 
> nothing changes. Is that what is to be expected?
> Cause I still have trouble with the dublicate entry key, but that must 
> be my code then.
>
> Thanks
> Martina
> _______________________________________________
> Biojava-l mailing list  -  Biojava-l at biojava.org
> http://biojava.org/mailman/listinfo/biojava-l


-- 
Bioinformatics Programmer
Pathogen Genomics
Institute for Biological Sciences
National Research Council of Canada
[T] 613-990-0561  [F] 613-952-9092
simon.foote at nrc-cnrc.gc.ca