Re: [gnome-db] GDA: PostgreSQL empty slots table

["Daniel Espinosa" <esodan gmail com>]

2008/2/27, Vivien Malerba <vmalerba gmail com>:
> I've tried to apply the patch to the V3 branch (named
>  release-3-0-branch/ in SVN) but could not make it compile:
>  gda-init.c: In function 'gda_create_table':
>  gda-init.c:329: error: 'GdaGeneralCreateTableFlag' undeclared (first
>  use in this function)
>  gda-init.c:329: error: (Each undeclared identifier is reported only once
>  gda-init.c:329: error: for each function it appears in.)
>  gda-init.c:329: error: expected ';' before 'flag'
>  gda-init.c:365: error: 'flag' undeclared (first use in this function)
>  gda-init.c:365: error: expected specifier-qualifier-list before
>  'GdaGeneralCreateTableFlag'
>  gda-init.c:368: error: 'GDA_GENERAL_CREATE_TABLE_NOTHING_FLAG'
>  undeclared (first use in this function)
>  gda-init.c:370: error: 'GDA_GENERAL_CREATE_TABLE_PKEY_FLAG' undeclared
>  (first use in this function)
>  gda-init.c:375: error: 'GDA_GENERAL_CREATE_TABLE_NOT_NULL_FLAG'
>  undeclared (first use in this function)
>  gda-init.c:380: error: 'GDA_GENERAL_CREATE_TABLE_AUTOINC_FLAG'
>  undeclared (first use in this function)
>  gda-init.c:385: error: 'GDA_GENERAL_CREATE_TABLE_PKEY_AUTOINC_FLAG'
>  undeclared (first use in this function)
>
>  Could you re-send me the patch for that branch?
>

Sure.

>  This is because I think there won't be a 3.2 release series, because
>  the V4 will be ready earlier than I thought, with much more features.
>
Great!, I'll prepare gda_create_table for V4, deprecating the actual
one on V3. For now I added gda_create_table_full in V3 in order to get
access to the futures of V4 without an API break.

>  Thanks (also for your patience since I tend to take a lot of time to
>  analyse patches...)

Thanks for you great work.

>
>  2008/2/19 Daniel Espinosa <esodan gmail com>:
>
> > 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 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 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)
>  >
>
> > _______________________________________________
>  >  gnome-db-list mailing list
>  >  gnome-db-list gnome org
>  >  http://mail.gnome.org/mailman/listinfo/gnome-db-list
>  >
>  >
>


-- 
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (entrámite, pero para los
cuates: LIBRE)