Error from the foreign RDBMS on a foreign table I have no privilege on

From: Phil Florent <philflorent(at)hotmail(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Error from the foreign RDBMS on a foreign table I have no privilege on
Date: 2022-06-04 21:18:02
Message-ID: PA4P191MB1600F8193E8F5B73821E7ADCBAA09@PA4P191MB1600.EURP191.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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&#39;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=*&gt;...
github.com

Best regards,
Phil

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2022-06-04 23:22:48 pgcon unconference / impact of block size on performance
Previous Message Tom Lane 2022-06-04 16:56:59 Re: Count output lines automatically in psql/help.c