<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - PostgreSQL Native Driver: AutoValue can't be created in GUI"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133349">133349</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PostgreSQL Native Driver: AutoValue can't be created in GUI
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>