Error from the foreign RDBMS on a foreign table I have no privilege on
Phil Florent <philflorent@hotmail.com>
From: Phil Florent <philflorent@hotmail.com>
To: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2022-06-04T21:18:02Z
Lists: pgsql-hackers
Hi, I opened an issue with an attached code on oracle_fdw git page : https://github.com/laurenz/oracle_fdw/issues/534 Basically I expected to obtain a "no privilege" error from PostgreSQL when I have no read privilege on the postgres foreign table but I obtained an Oracle error instead. Laurenz investigated and closed the issue but he suggested perhaps I should post that on the hackers list since it also occurs with postgres-fdw on some occasion (I have investigated some more, and postgres_fdw does the same thing when you turn on use_remote_estimate.). Hence I do... [https://opengraph.githubassets.com/e4d1de8890f6f00ee432d365f033677636df1c545e9d4c10ad623c5de5e7553e/laurenz/oracle_fdw/issues/534]<https://github.com/laurenz/oracle_fdw/issues/534> Oracle error on a foreign table I have no privilege on · Issue #534 · laurenz/oracle_fdw<https://github.com/laurenz/oracle_fdw/issues/534> Hi, I noticed a behaviour I didn't expect. Not really a bug but I obtained an Oracle error instead of a PostgreSQL error with a foreign table I had no privilege on. -- superuser prodige31=*>... github.com Best regards, Phil