Bug 133349 - PostgreSQL Native Driver: AutoValue can't be created in GUI
Summary: PostgreSQL Native Driver: AutoValue can't be created in GUI
Status: RESOLVED DUPLICATE of bug 60643
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-24 14:11 UTC by Robert Großkopf
Modified: 2020-07-08 03:43 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2020-05-24 14:11:15 UTC
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
Comment 1 Alex Thurgood 2020-07-07 16:18:23 UTC
@Robert, isn't this a DUP of bug 60643 ?
Comment 2 Robert Großkopf 2020-07-07 18:56:15 UTC
Alex, you are right.

*** This bug has been marked as a duplicate of bug 60643 ***