Got this warning: /pgsql/source/master/contrib/postgres_fdw/postgres_fdw.c: In function 'GetResultRelCheckAsUser': /pgsql/source/master/contrib/postgres_fdw/postgres_fdw.c:1898:7: warning: unused variable 'result' [-Wunused-variable] Oid result; ^~~~~~
I think the idea that GetRelPermissionInfo always has to scan the complete list by OID is a nonstarter. Maybe it would be possible to store the list index of the PermissionInfo element in the RelOptInfo or the RTE? Maybe use special negative values if unknown (it knows to search the first time) or known non-existant (probably a coding error condition, maybe not necessary to have this) -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/