[11.3.279 Pro] - BUG: fetching table properties in Postgres

[11.3.279 Pro] - BUG: fetching table properties in Postgres

When I try to get the table properties using the context menu / Properties from the Database Explorer in SQL Editor I get the following error message:

Quote:

Exception: Unable to retrieve properties of 'hkirogw'.'if_module'
Execute: PostgreSQL Error (1): PQsendQueryParams
Client: 12.0.1
Server: 12.0.4
SQL State: 42703, ERROR: column rel.relhasoids does not exist

SELECT rel.oid, rel.relname, rel.reltablespace AS spcoid, spc.spcname, pg_get_userbyid(rel.relowner) AS relowner, rel.relacl, rel.relhasoids, rel.relhassubclass, rel.reltuples, des.description, con.conname, con.conkey, EXISTS(select 1 FROM pg_trigger JOIN pg_proc pt ON pt.oid=tgfoid AND pt.proname='logtrigger' JOIN pg_proc pc ON pc.pronamespace=pt.pronamespace AND pc.proname='slonyversion' WHERE tgrelid=rel.oid) AS isrepl, (select count(*) FROM pg_trig.

I tried to find that in the SA Options / DB Options / DB Queries for Postgres but as the rest of the query is cropped from the message, I have not succeeded.

This error is caused by backward incompatible change introduced in PG v12. Object identifiers OIDs are no longer treated as special columns, but instead of deprecating related attributes like "relhasoids" column in the system catalog, PostgreSQL developers removed it all together.

We will have compatibility fix in the upcoming maintenance release (soon, beginning of January)

This one is fixed as well.