Re: Problem with search_path and creating objects

Thank you!  That was it.  Somehow the search_path for the user had an extra set of quotes.  I have no idea where that happened.

I will have to pay more attention when I set up the next user! :-/

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.