Re: SET ROLE and search_path - Mailing list pgsql-general

From Stephen Frost
Subject Re: SET ROLE and search_path
Date
Msg-id 20200520215447.GO3418@tamriel.snowman.net
Whole thread Raw
In response to Re: SET ROLE and search_path  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Rob Sargent <robjsargent@gmail.com> writes:
> > Am I (again) alone in finding this a bit hokey?  That a user name just
> > happens to be a schema name ...
>
> That's actually strongly encouraged by the SQL spec, if memory serves.

... and all-but-required by some other database systems.  Doesn't make
it a good idea tho, imv.

Thanks,

Stephen

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SET ROLE and search_path
Next
From: Adrian Klaver
Date:
Subject: Re: How to recover from compressed wal archieve in windows