https://bugs.freedesktop.org/show_bug.cgi?id=60643
--- Comment #2 from Lionel Elie Mamane <[email protected]> --- This happens in connectivity/source/commontools/dbtools2.cxx, function dbtools::createStandardColumnPart, around lines 90-91 and 171-175. This generates the SQL for creating the new column. That code pretty much expects to be able to just stack some text behind the: "colName" colType NOT NULL and that would magically make it an autoincrement column. Alas, that is not how it happens in PostgreSQL; we need to either explicitly create the sequence and set the default value to nextval('seqname') OR change colType to one of smallserial, serial or bigserial (depending on the underlying type: int2, int4 or int8). See http://www.postgresql.org/docs/9.2/static/datatype-numeric.html#DATATYPE-SERIAL Since dbtools::createStandardColumnPart merrily ignores the auto_increment (column 12) of getTypeInfo(), we cannot even use that at the pgsql-sdbc level to assert *some* control. So, "any" solution will have to happen by a redesign of dbtools::createStandardColumnPart, and probably some new SDBCX interface that drivers would have to implement. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
