Bug 502600 - Kexi not compatible with Postgresql 12 onwards
Summary: Kexi not compatible with Postgresql 12 onwards
Status: REPORTED
Alias: None
Product: KEXI
Classification: Applications
Component: General (show other bugs)
Version: 3.2.0
Platform: Arch Linux Linux
: VHI critical
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-09 09:58 UTC by Ian Balchin
Modified: 2025-04-11 14:04 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ian Balchin 2025-04-09 09:58:04 UTC
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/