Re: [GUSDEV] setting nasequenceimp.sequence_version in 3.5

[Mark S. H. <mh...@ug...>]

ok. I don't know if any other plugins rely on the schema setting  
default values. In the interest of moving forward I will update the  
dbEST plugin to set a value so there will be a workable solution  
regardless of what's decided later. That seems to be the simplest  
(trivial, now that I see how to do it) and most robust solution.

Thanks,
M

On Jul 19, 2005, at 11:42 AM, Michael Saffitz wrote:

>
> 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
>>
>
>
>