Re: BUG #16195: current_schema always return "public"

Julien Rouhaud <[email protected]> Tue, 7 Jan 2020 17:29:42 +0100

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<CAOBaU_Y9X1mjWE0E5jBpqgjbJKS=Okm-D8=yPyR_f_LuqcTBbA@mail.gmail.com>

On Tue, Jan 7, 2020 at 5:07 PM PG Bug reporting form
<[email protected]> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:      16195
> Logged by:          Boris Kalimira
> Email address:      [email protected]
> PostgreSQL version: 12.1
> Operating system:   CentOS 7 &amp; 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?