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

From Etsuro Fujita
Subject Re: Error from the foreign RDBMS on a foreign table I have no privilege on
Date
Msg-id CAPmGK16aRNdPpVe0TMZqSA3gXrkdC=KVNbGiLZZK4YTnZydEXg@mail.gmail.com
Whole thread Raw
In response to Re: Error from the foreign RDBMS on a foreign table I have no privilege on  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
On Fri, Jun 10, 2022 at 1:26 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> On Thu, 2022-06-09 at 21:55 +0900, Etsuro Fujita wrote:
> > However, I'm not 100% sure we really need to document
> > something about this, because 1) this doesn't cause any actual
> > problems, as you described, and 2) this is a pretty-exceptional case
> > IMO.
>
> I am not sure if it worth adding to the documentation.  I would never have thought
> of the problem if Phil hadn't brought it up.  On the other hand, I was surprised
> to learn that permissions aren't checked until the executor kicks in.
> It makes sense, but some documentation might help others in that situation.

+1 for adding such a document.

> I'll gladly leave the decision to your judgement as a committer.

IIRC, there are no reports about this from the postgres_fdw users, so
my inclination would be to leave the documentation alone, for now.

Best regards,
Etsuro Fujita



pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Multi-Master Logical Replication
Next
From: Andrey Borodin
Date:
Subject: Re: better page-level checksums