pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #16195: current_schema always return "public"
3+ messages / 3 participants
[nested] [flat]
* BUG #16195: current_schema always return "public"
@ 2020-01-07 16:06 PG Bug reporting form <noreply@postgresql.org>
2020-01-07 16:29 ` Re: BUG #16195: current_schema always return "public" Julien Rouhaud <rjuju123@gmail.com>
2020-01-09 04:15 ` Re: BUG #16195: current_schema always return "public" Michael Paquier <michael@paquier.xyz>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2020-01-07 16:06 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: kalimira.boris@gmail.com
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16195: current_schema always return "public"
2020-01-07 16:06 BUG #16195: current_schema always return "public" PG Bug reporting form <noreply@postgresql.org>
@ 2020-01-07 16:29 ` Julien Rouhaud <rjuju123@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Julien Rouhaud @ 2020-01-07 16:29 UTC (permalink / raw)
To: kalimira.boris@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #16195: current_schema always return "public"
2020-01-07 16:06 BUG #16195: current_schema always return "public" PG Bug reporting form <noreply@postgresql.org>
@ 2020-01-09 04:15 ` Michael Paquier <michael@paquier.xyz>
1 sibling, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2020-01-09 04:15 UTC (permalink / raw)
To: kalimira.boris@gmail.com; pgsql-bugs@lists.postgresql.org
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
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2020-01-09 04:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-01-07 16:06 BUG #16195: current_schema always return "public" PG Bug reporting form <noreply@postgresql.org>
2020-01-07 16:29 ` Julien Rouhaud <rjuju123@gmail.com>
2020-01-09 04:15 ` Michael Paquier <michael@paquier.xyz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox