Thread: BUG #16195: current_schema always return "public"
The following bug has been logged on the website: Bug reference: 16195 Logged by: Boris Kalimira Email address: kalimira.boris@gmail.com PostgreSQL version: 12.1 Operating system: CentOS 7 & Windows Description: Context: user "test" and schema "test" created on my DB. Connencted as test user on my DB: SHOW search_path -> "$user", public SELECT current_schema -> public Expectation -> SELECT current_schema -> test
On Tue, Jan 7, 2020 at 5:07 PM PG Bug reporting form <noreply@postgresql.org> wrote: > > The following bug has been logged on the website: > > Bug reference: 16195 > Logged by: Boris Kalimira > Email address: kalimira.boris@gmail.com > PostgreSQL version: 12.1 > Operating system: CentOS 7 & Windows > Description: > > Context: > user "test" and schema "test" created on my DB. > > Connencted as test user on my DB: > SHOW search_path -> "$user", public > SELECT current_schema -> public > > Expectation -> SELECT current_schema -> test Is "test" role owner of the "test" schema, or does it have usage privilege on it?
On Tue, Jan 07, 2020 at 04:06:05PM +0000, PG Bug reporting form wrote: > Context: > user "test" and schema "test" created on my DB. > > Connencted as test user on my DB: > SHOW search_path -> "$user", public > SELECT current_schema -> public > > Expectation -> SELECT current_schema -> test With a database role named test: =# show search_path ; search_path ----------------- "$user", public (1 row) =# select current_schema(); current_schema ---------------- public (1 row) =# create schema test; CREATE SCHEMA =# select current_schema(); current_schema ---------------- test (1 row) So your expectation is right, but not your test. -- Michael