[Libreoffice-bugs] [Bug 125186] New: AutoValue does not work with PostgreSQL

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125186
           Summary: AutoValue does not work with PostgreSQL
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: seb.lo at ldd.fr

Description:
Setting AutoValue to an integer column of a new table is ignored in PostgreSQL
databases.

Steps to Reproduce:
1. Connect to a PostgreSQL database
2. Create Table in Design View
3. Field name: "id"
   Field type: "Integer [ int 4 ]"
   AutoValue: "Yes"
4. Add a text field
Save to Schema "public", table name: "t"
5. Open table "t" to input data

Actual Results:
Column "id" must be filled-in.
It was created as integer not null primary key.


Expected Results:
Column "id" should show "<AutoField>" placeholder and not require user input.
It should have been created as serial primary key.
Sequence t_id_seq would have been created
and nextval('t_id_seq'::regclass) would have been set as default value.



Reproducible: Always


User Profile Reset: Yes



Additional Info:
Workaround: use Tools / SQL… or an external tool to create tables, then restart
LibreOffice so it reloads database information. View / Refresh Table is not
enough to get the "<AutoField>" placeholder.

Example:
create table t(id serial primary key, name varchar(100))

I can reproduce this bug using versions 5.4.0.3 and current dev build
(6.3.0.0.alpha0+)

Version: 6.3.0.0.alpha0+
Build ID: 98630a0bd49bd80652145a21e4e0d0ded792b36b
CPU threads: 4; OS: Linux 4.9; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64 at 86-TDF, Branch:master, Time:
2019-05-04_04:44:35
Locale: fr-FR (fr_FR.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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/20190509/23fad795/attachment.html>