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