Bug 502600

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/