Re: Problem with search_path and creating objects - Mailing list pgsql-novice

> On Aug 18, 2015, at 10:09 AM, Eric Raskin <eraskin@paslists.com> wrote:
>
> $ psql -U sbowner -d pas -h postgres
> Password for user sbowner:
> psql (9.4.4)
> Type "help" for help.
>
> pas=> show search_path;
>     search_path
> -------------------
>  "sbowner, public"
> (1 row)
>


I think the key question is where the search_path got set to "sbowner, public". If you had the default setting in
postgresql.conf:

#search_path = '"$user",public'        # schema names

It should look just like this:

pas=> show search_path;
  search_path
----------------
 "$user",public
(1 row)


Are you sure you don't have search_path attached to a user? And you have reset the one you had for the database?

Maybe try

alter database pas set search_path to default;

alter user sbowner set search_path to default;

Then logout and back in to show the search_path.


John DeSoi, Ph.D.