GDA: PostgreSQL empty slots table

[Daniel Espinosa]

Please see at attachment for a patch to add AUTOINC (set type to
serial) on Postgresql.

Hops this helps to Phil in the problem to autoincrement Pkey at
Postgresql GDA provider,

This will close Bugs: #515306 and #515528


Just wait for gnome-db developers to review it.

2008/2/7, Mark Johnson <mrj001 at shaw.ca>:
> 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
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (entrámite, pero para los
cuates: LIBRE)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PATCH-AUTOINC-PostgreSQL-CreateTableConvenientFunction.diff
Type: text/x-patch
Size: 21279 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20080219/71a2c53a/attachment.bin