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@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.
--
-----------------------------------------------------------------------------------------------------------------------------------------------