GDA save missing records

Derek Atkins warlord at MIT.EDU
Sun Feb 17 12:27:11 EST 2008


Mark Johnson <mrj001 at shaw.ca> writes:

> Mark Johnson wrote:
>> This appears to be separate from the SERIAL problem of libgda's 
>> PostgreSQL provider as PostgreSQL has the highest number of splits.  
>> (Most complete?  Are there duplicates?)
>>
>>
>>   
> Oops, no it doesn't have the highest number of splits.  It is three less 
> than MySql.  Naturally, I should not expect duplicate records - the 
> primary key should prevent this.
>
> By comparing the splits in the PostgreSQL DB to the MySQL DB, I found 
> that three were missing from the PostgreSQL copy.  By searching the 
> PostgreSQL log file for errors inserting those guids, I found that, in 
> all three instances, I had entered text for the memo field that was 
> longer than the 50 characters allowed (by the DB schema).  PostgreSQL 
> responded by refusing to enter that record.  MySQL simply truncated the 
> data.
>
> So how many characters are allowed in a memo field?

All text fields are "unlimited".  This includes the description, the
memo, the action, the number column, etc.

> MySql and PostgreSQL had identical lists of account guids and 
> transaction guids.
>
> It will take more effort to find out why things are missing in SQLite as 
> I am not aware of any error log files.
>
> Mark

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-devel mailing list