Re: Problem with search_path and creating objects

> On Aug 18, 2015, at 10:09 AM, Eric Raskin <eraskin(at)paslists(dot)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.