https://bugs.documentfoundation.org/show_bug.cgi?id=147497
Bug ID: 147497
Summary: PostgreSQL direct connection: AutoValue wont be shown
in table when created with "generated by default…"
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Open a PostgreSQL-database with direct connection.
Connect to database through click on the Tables pane.
Start Tools → SQL.
Execute
CREATE TABLE public.distributors (
did
integer PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
name
varchar(40) NOT NULL
);
Close Tools → SQL
Refresh tables and you could see the table.
Open the table for input data.
No AutoValue appears.
Type something in column "name" and set to next row.
'0' appears as "did".
You could input a lot of content and always '0' appears.
You have to reload the table and the values would appear.
Direct connection couldn't handle autovalue created by "Generated by default as
identity".
Direct connection doesn't save autovalue through GUI (another bug 60643).
Direct connection will only show autovalue when created as "serial". This is a
second (special) way to create such a field in PostgreSQL.
--
You are receiving this mail because:
You are the assignee for the bug.
