[Babase] next conversion run

Karl O. Pinc kop at meme.com
Mon Dec 4 17:03:07 EST 2006


On 12/04/2006 11:27:34 AM, kfenn wrote:
> I uploaded the database as DATA_tf on Papio.  I didn't want to get  
> rid of any of the old files lest my "corrected" file be worse than  
> the originals.  I also uploaded BABASE_CHANGELOG_TF and  
> REAL_CYCGAPS_TF.  I don't think there were any more changes to the  
> fake_cycgaps_tf or undo_fake_cycgaps_tf from the last conversion so I  
> have not re-loaded these to papio.

There are some errors in real_cycgaps that look like:
psql:<stdin>:248: ERROR:  value too long for type character(1)
psql:<stdin>:270: ERROR:  value too long for type character(1)

These are because you put the word "NULL" into single quotes.
NULL is a special value that does not need to be quoted,
whereas 'NULL' is the letters N, U, L, L as text.  The
different syntax exists so that you can enter either of
the two values into the database.

We'll just take a look at the errors that come out and run another
conversion.


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