[GENERAL] Setting search_path ignored - Mailing list pgsql-general

From Guyren Howe
Subject [GENERAL] Setting search_path ignored
Date
Msg-id CABzyXqYKw-tJ-4OZQNLwyS1TSrEuSiqyRoDvcR8Rvao=ZdWAKA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Setting search_path ignored  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general

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", public

(1 row)

 

This seems to contradict all the advice I can find about setting the schema search path.

pgsql-general by date:

Previous
From: "Frank Millman"
Date:
Subject: Re: [GENERAL] a JOIN to a VIEW seems slow
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] time series data