Hello
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Guyren Howe
Sent: Montag, 2. Oktober 2017 16:10
To: David G. Johnston
Cc: PostgreSQL General
Subject: Re: [GENERAL] Setting search_path ignored
I logged out and back and did SET ROLE
On Mon, Oct 2, 2017 at 7:09 AM, Guyren Howe wrote:
> I logged out and back and did SET ROLE and got the same resullt.
>
Are you logging in as "thing_accessor" or some role that is a member of
"thing_accessor"?
David J.
I logged out and back and did SET ROLE and got the same resullt.
On Oct 2, 2017, 10:06 -0400, David G. Johnston ,
wrote:
> On Mon, Oct 2, 2017 at 7:00 AM, Guyren Howe wrote:
> > > CREATE ROLE thing_accessor;
> > > CREATE ROLE
> > > CREATE SCHEMA thing_accessor;
> > > CREATE SCHEMA
> > > covermyt
On Mon, Oct 2, 2017 at 7:00 AM, Guyren Howe wrote:
> CREATE ROLE thing_accessor;
>
> CREATE ROLE
>
> CREATE SCHEMA thing_accessor;
>
> CREATE SCHEMA
>
> covermything=> ALTER ROLE thing_accessor SET search_path=thing_accessor;
>
> ALTER ROLE
>
> covermything=# SET ROLE thing_accessor;
>
> SET
>
>
CREATE ROLE thing_accessor;
CREATE ROLE
CREATE SCHEMA thing_accessor;
CREATE SCHEMA
covermything=> ALTER ROLE thing_accessor SET search_path=thing_accessor;
ALTER ROLE
covermything=# SET ROLE thing_accessor;
SET
covermything=> SHOW search_path;
search_path
-
"$user",
