GDA: PostgreSQL empty slots table

Mark Johnson mrj001 at shaw.ca
Thu Feb 7 03:19:34 EST 2008


The slots table includes an id field which is "auto_increment".  
PostgreSQL does not implement that keyword.  Instead, it appears to 
accept it, but ignore it when creating the table.  (This may actually be 
libgda's PostgreSQL provider doing that.)  Gnucash-gda relies upon that 
field auto-incrementing when inserts are done to the slots table.  The 
result is similar to this for every insert to the slots table:
ERROR:  null value in column "slot_id" violates not-null constraint
STATEMENT:  INSERT INTO slots (obj_guid, name, slot_type, int64_val, 
string_val, double_val, timespec_val, guid_val, numeric_val_num, 
numeric_val_denom) VALUES ('77889f8da5fb434ae68891da19bef5ad', 
'reconcile-info/last-date', 1, 1199170799, NULL, NULL, '1969-12-31', 
NULL, 0, 1)

When saving to the gda backend, both MySql and sqlite have many records 
in the slots table.  PostgreSQL ends up with none.

Mark



More information about the gnucash-devel mailing list