[BioSQL-l] Error in load_ncbi_taxonomy.pl

[Marc Colosimo]

Thanks, I dropped the table and used the one from the cvs version and it 
works. However, it is a bit slow in loading. This is a fast machine, but 
it is a stock build of postgresql.

marc

On Tue, 18 Mar 2003, Aaron J Mackey 
wrote:

> 
> Yeah, I just got bit by this today too; fixes are already checked in to
> CVS; you'll need to reinstantiate the database from the .sql (or at least
> the fktaxon foreign key constraint).
> 
> -Aaron
> 
> On Tue, 18 Mar 2003, Marc Colosimo wrote:
> 
> > I tried using load_ncbi_taxonomy.pl (Rev 1.3 from 119 mins) and got this
> > error:
> >
> > [mcolosim]$ ./load_ncbi_taxonomy.pl -dbname bioseqdb -driver pg
> > DBD::Pg::st execute failed: ERROR:  fktaxon_taxon referential integrity
> > violation - key referenced from taxon not found in taxon at
> > ./load_ncbi_taxonomy.pl line 142.
> > DBD::Pg::st execute failed: ERROR:  fktaxon_taxon referential integrity
> > violation - key referenced from taxon not found in taxon at
> > ./load_ncbi_taxonomy.pl line 142.
> >
> >
> > _______________________________________________
> > BioSQL-l mailing list
> > BioSQL-l at open-bio.org
> > http://open-bio.org/mailman/listinfo/biosql-l
> >
> 
>