Re: Search path

2019-10-24 Thread Thomas Kellerer
stan schrieb am 24.10.2019 um 18:41: > I just was educated on the security issues of search path. As a result > I am going to define a schema for the project we are working on. > I set this in postgresql.conf > > search_path = 'ica , "$user", public' > > Here is the question. Will this path be i

Re: Search path

2019-10-24 Thread Adrian Klaver
On 10/24/19 9:41 AM, stan wrote: I just was educated on the security issues of search path. As a result I am going to define a schema for the project we are working on. I set this in postgresql.conf search_path = 'ica , "$user", public' Here is the question. Will this path be in effect for use

Re: Search path & functions in temporary schemas

2018-12-11 Thread Tom Lane
jose luis pillado writes: > This solution worked with a real schema, but it did not with a temporary > one. ... > Is there any way to make this work? The temp schema is intentionally excluded from the search path for functions and operators, because otherwise it's just too easy to trojan-horse th