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 08/18/2015 03:44 PM, John DeSoi wrote:
>> 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.
>
>

--
-----------------------------------------------------------------------------------------------------------------------------------------------
Eric H. Raskin 914-765-0500 x120
Professional Advertising Systems Inc. 914-765-0503 fax
200 Business Park Dr Suite 304 eraskin(at)paslists(dot)com
Armonk, NY 10504 http://www.paslists.com