https://bugs.kde.org/show_bug.cgi?id=502600
Bug ID: 502600
Summary: Kexi not compatible with Postgresql 12 onwards
Classification: Applications
Product: KEXI
Version: 3.2.0
Platform: Arch Linux
OS: Linux
Status: REPORTED
Severity: critical
Priority: NOR
Component: General
Assignee: kexi-b...@kde.org
Reporter: in...@fables.co.za
CC: a...@piggz.co.uk, in...@fables.co.za
Target Milestone: ---
PRELIMINARY.
The removal from Postgresql of support for OIDS with Version 12 leaves Kexi
incompatible with Postgresql Version 12 through to the current Version 16
SUMMARY
The following Postgresql error occurs when connecting to Postgresql, even when
just ‘Testing’ a connection.
ERROR: tables declared with OIDS are not supported
STATEMENT: SET DEFAULT_WITH_OIDS TO ON
When ‘Saving’ a created table the following Kexi error is given
Saving object's definition failed.
Transaction not started.
STEPS TO REPRODUCE
1. Have installed the latest version of Postgreql on remote server.
2. Ensure needed Postgresql extensions are installed. 'fuzzystrmatch' is one
3. Run as root: # tail -f /var/postgresql/logfile
4. Using Kexi create a connection and ‘Test Connection’
5. Create a new Kexi database
6. Create a table with some small number of fields for testing purposes
7. Save table
OBSERVED RESULT
When editing the connection and ‘Testing’ same:
"Test connection to "postgres@192.168.0.21" database server established
successfully"
Plus Postgresql error on tailed logfile:
ERROR: tables declared with OIDS are not supported
STATEMENT: SET DEFAULT_WITH_OIDS TO ON
When saving the Kexi table:
Saving object's definition failed.
Transaction not started.
EXPECTED RESULT
No Postgresql Error message re OIDS
Kexi table to be saved successfully.
SOFTWARE/OS VERSIONS
Linux/Majaro/Xfce: fully updated
Kexi 3.2.0
Postgresql 16.8
OpenBSD 7.6 fully updated
ADDITIONAL INFORMATION
This has persisted for some long time now and its true extent only became
apparent after examining the Postgresq logfile. Further research reveals:
“Postgresql introduced a significant change with version 12: the
discontinuation of the Object Identifier (OID) datatype”
https://opensource-db.com/postgresql-oid-datatype-impacts-and-remedies/
--
You are receiving this mail because:
You are watching all bug changes.
