Bug 121165 - postgreSQL-SDBC : cannot enter, delete or edit data without primary key
Summary: postgreSQL-SDBC : cannot enter, delete or edit data without primary key
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-04 19:26 UTC by Stéphane Aulery
Modified: 2018-11-05 08:28 UTC (History)
3 users (show)

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 Stéphane Aulery 2018-11-04 19:26:53 UTC
Description:
Data manipulation is not possible without a primary key on the table.

---------------------------------------------------------------------

Dear Maintainer,

opening a table for data editing (by pressing Enter or double-clicking &c.) only shows the
column names in the header, otherwise the window is completely empty and all controls
greyed out. If data are inserted using the commandline tool PSQL, they show up in LO but
cannot be changed.

New tables can be created and new columns added but no attributes of existing columns can be changed.

Everything can be done from the same computer on the same server using PSQL with the same
user and password.

LO reports no errors.

I tested this using different installations on different machines both as clients and
servers, including using LO on the server itself.


Actual Results:
--

Expected Results:
Editing tables without a primary keay


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 m_a_riosv 2018-11-04 20:51:14 UTC
https://wiki.documentfoundation.org/Faq/Base/005

Please if you a not agree reopen it.