At Thu, 16 Mar 2023 09:32:05 +0530, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote in
> On Thu, Mar 16, 2023 at 7:47 AM Kyotaro Horiguchi
> <horikyota.ntt@gmail.com> wrote:
> > Thus I think that the message should read "path must be in or below
> > the data directory" instead.
> >
> > What do you think about making this change?
>
> Well yes. As far as postgres processes are concerned their working
> directory is set to data directory by the postmaster in
> ChangeToDataDir() and all the children will inherit that setting. So,
> I see nothing wrong in being explicit about it in the error messages.
Yeah, you're right.
> BTW, adminpack too has the same error message.
I somehow dropped them. Thanks for pointing.
> FWIW, here are the steps to generate the error:
> create role foo with nosuperuser;
> grant execute on function pg_ls_dir(text) to foo;
> set role foo;
> select * from pg_ls_dir('..');
Oh, thank you for the clarification about the reproduction method.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center