Postgres Pro
Downloads
Home   >   mailing lists

Error from the foreign RDBMS on a foreign table I have no privilege on - Mailing list pgsql-hackers

From Phil Florent
Subject Error from the foreign RDBMS on a foreign table I have no privilege on
Date
Msg-id PA4P191MB1600F8193E8F5B73821E7ADCBAA09@PA4P191MB1600.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Error from the foreign RDBMS on a foreign table I have no privilege on
List pgsql-hackers
Tree view
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...
Best regards,
Phil

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Count output lines automatically in psql/help.c
Next
From: Tomas Vondra
Date:
Subject: pgcon unconference / impact of block size on performance