Re: [Gusdev-gusdev] increasing space for externalaasequence.name

[<ju...@cs...>]

"Sucheta Tripathy" <su...@vb...> writes:
>
> I am now uploading data to the externalaasequence, and frequently it gets
> interrupted because the name has data type varchar2(255), where as some of
> the names are much longer than that.I was wondering if the table
> definition can be changed in the distribution to handle this OR is there a
> reason why this should be kept as varchar2(255)?

The description column of ExternalNASequence is of type varchar2(2000),
which should be long enough for the full name of your sequence.

A problem we have run into is that the table DoTS.NAFeature
only has the field "name" to describe the feature:

   column          nulls?  type
   name            no      varchar2(30)

and could really use a description field such as:

   description        varchar2(2000)

as the genbank description for many features significantly
exceeds 30 characters.  Sure, the table DoTS.NAFeatureComment
with its "comment_string clob(4000)" column exists, but that
NAFeature lacks a description column is inconsistent with other
GUS tables.


Josef



Josef Jurek, Ph.D.

Daphne Preuss Laboratory
Molecular Genetics and Cell Biology
The University of Chicago
ju...@cs...

voice: (773) 834-3985
fax:   (773) 702-6648