Re: Error from the foreign RDBMS on a foreign table I have no privilege on
Etsuro Fujita <etsuro.fujita@gmail.com>
From: Etsuro Fujita <etsuro.fujita@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, euler@eulerto.com,
philflorent@hotmail.com, pgsql-hackers@lists.postgresql.org
Date: 2022-06-10T08:17:22Z
Lists: 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