[Bioperl-guts-l] [Bug 2389] load_seqdatabase.pl crashes on varchar(n)

bugzilla-daemon at portal.open-bio.org bugzilla-daemon at portal.open-bio.org
Sun Oct 28 16:15:55 EDT 2007


http://bugzilla.open-bio.org/show_bug.cgi?id=2389





------- Comment #1 from er at xs4all.nl  2007-10-28 16:15 EST -------
Created an attachment (id=796)
 --> (http://bugzilla.open-bio.org/attachment.cgi?id=796&action=view)
biosqldb-pg.sql - varchar(n) to text

biosqldb-pg.sql creates columns of type 'varchar(n)' which are generally better
replaced with 'TEXT'. ( load_seqdatabase.pl crashes on varchar(n) when loading
uniprot_sprot.dat )

see ftp.ebi.ac.uk/pub/databases/uniprot/current_release/knowledgebase/complete/ 

patch changes the tables definitions varchar and varchar(n), to text.

(in case the patch is accepted I'll submit a alter table script as well, if
needed)


-- 
Configure bugmail: http://bugzilla.open-bio.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.


More information about the Bioperl-guts-l mailing list