[Babase] Re: rain - need more digits!!

Karl O. Pinc kop at meme.com
Thu Sep 9 10:56:26 EDT 2010


On 09/09/2010 09:30:00 AM, Niki Learn wrote:
> Karl,
> 
>  
> 
> I am running the demography upload in test, as you know, and I am 
> near
> the
> end.  I am trying to upload the min_maxs date but have hit this 
> error:
> 
> Line 8: ERROR: numeric field overflow DETAIL: The absolute value is
> greater
> than or equal to 10^2 for field with precision 3, scale 1.
> 
> This is because we had 130.8mm of rain (overnight!) on the morning of
> 7
> January.  So I need to change the numeric from 3,1 to 4,1.  But 
> babase
> won't
> let me change the type, even as admin.  Does that mean you have to do
> it?
> It will let someone change it, right?

Apparently it won't change because there's views that use the column.

I've made the change and added another integrity check that says there
can't be more than 200mm of rain.  Is this a good upper limit?

I need to make these sorts of changes so that code used to (re)create
the database accurately reflects the real database structure.
This also ensures the documentation is kept in sync.



Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein




More information about the Babase mailing list