Re: security_definer_search_path GUC - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: security_definer_search_path GUC
Date
Msg-id 0b55d239-5f63-4a25-ae28-61e0ef4b2415@www.fastmail.com
Whole thread Raw
In response to Re: security_definer_search_path GUC  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: security_definer_search_path GUC
List pgsql-hackers
On Fri, Jun 4, 2021, at 08:58, Pavel Stehule wrote:
It is the same as using the command line without the possibility to customize the PATH variable. The advantages and disadvantages are exactly the same.

The reason why we even have PATH in the *nix world,
is not because they *wanted* to separate things (like we want with schemas or extensions),
but because they *needed* to, because /bin was overflowed:

"The UNIX shell gave up the Multics idea of a search path and looked for program names that weren’t
file names in just one place, /bin. Then in v3 /bin overflowed the small (256K), fast fixed-head drive.
Thus was /usr/bin born, and the idea of a search path reinstated." [1]


/Joel

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Skip partition tuple routing with constant partition key
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Race condition in recovery?