[Libreoffice-bugs] [Bug 133349] New: PostgreSQL Native Driver: AutoValue can't be created in GUI

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133349

            Bug ID: 133349
           Summary: PostgreSQL Native Driver: AutoValue can't be created
                    in GUI
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Open a database, which connects with the native driver to PostgreSQL.
Create a table in schema "public":
ID Int AutoValue
Name Varchar

You could see ID is set as Primary Kay and AutoValue is set to "Yes".
Save this table.
Don't close, look at the greyed out information: 
AutoValue is set to yes.

Close the dialog.
open the table for input data - no AutoValue could be found.

Close whole LO for new connection to PostgreSQL.
Reopen the database.
No AutoValue there.

Reopen the table for editing.
Look at ID - AutoVaule is set to "No".

You could create a AutoValue in Tools > SQL:
CREATE TABLE autor (
    id serial NOT NULL,
    name text NOT NULL,
    CONSTRAINT autor_pkey PRIMARY KEY (id)); 

With "serial" an AutoValue will be created ...

This bug appears in LO 6.4.4.2 on OpenSUSE 15.1 64bit rpm Linux. But it is also
the same behavior, for example, in LO 6.1.5.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200524/e92cc16f/attachment-0001.htm>