At Thu, 16 Mar 2023 09:32:05 +0530, Bharath Rupireddy <bharath.rupireddyforpostg...@gmail.com> wrote in > On Thu, Mar 16, 2023 at 7:47 AM Kyotaro Horiguchi > <horikyota....@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