https://bugs.documentfoundation.org/show_bug.cgi?id=171322
Bug ID: 171322
Summary: Automatically created primary key column in
PostgreSQL-backed Base should be auto-populating
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
I have a table in an ODS-backed Database with two columns.
I create a table in a PostgreSQL-backed Database with the same two columns.
When I go to save the table it tells me that it needs to create a primary key,
so I tell it to go ahead and do that. (Not really clear why that should be
necessary, PostgreSQL certainly doesn't require primary keys on all tables, but
whatever.)
Now I copy the table from the ODS-backed Database and attempt to paste it into
the newly created table in the PostgreSQL-backed Database. When prompted, I
tell it that I want to append the data to the table. When prompted to set up
the column mappings, I map the two columns that exist in the source table and
ignore the automatically created ID column under the assumption that it will
auto-populate.
Nope! I get an error when LibreOffice attempts to insert the data into the
database because the ID column can't be null.
Automatically created ID columns really should be auto-incrementing.
--
You are receiving this mail because:
You are the assignee for the bug.
