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

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, euler(at)eulerto(dot)com, philflorent(at)hotmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Error from the foreign RDBMS on a foreign table I have no privilege on
Date: 2022-06-10 08:17:22
Message-ID: CAPmGK16aRNdPpVe0TMZqSA3gXrkdC=KVNbGiLZZK4YTnZydEXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 10, 2022 at 1:26 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2022-06-10 08:21:43 Re: better page-level checksums
Previous Message Bharath Rupireddy 2022-06-10 07:10:15 Re: Multi-Master Logical Replication