Re: Patch to allow setting schema/search_path in the connectionURL - Mailing list pgsql-jdbc

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