On 9/22/2014 10:30 PM, stagirus wrote:
> I am getting "$user,public"
> When ran, in PG Query Tool, SHOW SEARCH_PATH;
That's the default, implying you haven't set the search_path in use at
the time you did your CREATE TABLE ... if there is no schema matching
$USER (the current role name), then it will try public, which apparently
you deleted.
were you logged in as the user for whom you'd done the ALTER ROLE name
SET SEARCH_PATH TO ...; ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast