BUG #16195: current_schema always return "public"

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: kalimira(dot)boris(at)gmail(dot)com
Subject: BUG #16195: current_schema always return "public"
Date: 2020-01-07 16:06:05
Message-ID: 16195-79075d7d4aed31ab@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16195
Logged by: Boris Kalimira
Email address: kalimira(dot)boris(at)gmail(dot)com
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Julien Rouhaud 2020-01-07 16:29:42 Re: BUG #16195: current_schema always return "public"
Previous Message Robert Haas 2020-01-07 15:59:22 Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema