Re: [GUSDEV] setting nasequenceimp.sequence_version in 3.5

[Michael S. <msa...@pc...>]

Hi Mark,

The 3.5 schema installation doesn't set any default values.  Please file
this as a bug so we can review and decided whether to either:

* fix the install to set default values
* to make these columns nullable
* to update plugins/code to set values

--Mike

On 7/19/05 12:24 AM, "Mark S. Heiges" <mh...@ug...> wrote:

> ApiComplexa::DataLoad::Plugin::dbEST is the same as
> GUS::Community::Plugin::dbEST (recently renamed to
> LoadFromdbESTMirror.pm) except it reads from a remote database link
> to Penn's dbEST mirror.
> 
> With GUS 3.5 it throws the error
>      cannot insert NULL into ("DOTS"."NASEQUENCEIMP"."SEQUENCE_VERSION")
> 
> This error is clear enough but this was not a problem in GUS 3.0
> where sequence_version would always get set to '1'.
> Sequence_version doesn't seem to get set by dbEST so apparently there
> is some default assignment elsewhere. Checking a GUS3.0 Oracle
> instance, there appears to be a default value defined in the
> NaSequenceImp table definition that I don't have in my 3.5 instance.
> 
> Does sequence_version need to be explicitly set by plugins for 3.5 or
> is my  3.5 NaSequenceImp table erroneously missing a default value
> for that column?
> 
> 
> -M
> 
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev