Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: Patch to allow setting schema/search_path in the connectionURL
Date
Msg-id 54210115.7060203@hogranch.com
Whole thread Raw
In response to Re: Patch to allow setting schema/search_path in the connectionURL  (stagirus <mamasa@stagirus.com>)
Responses Re: Patch to allow setting schema/search_path in the connectionURL
List pgsql-jdbc
Tree view 
On 9/22/2014 10:07 PM, stagirus wrote:
> Sorry John. I don't see much of a difference in those two commands. For all
> practical purpose, in our design the "public" schema has no role. I delete
> it.

then what is the meaning of your statement...

> Then ran a bunch of SQL commands after connecting to the user dev. But it
> fails because it is looking for the "public" schema. I am not sure how this
> "ALTER ROLE" works.

?     /what/ is looking for the public schema ?   what is the exact
error you are getting ?




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-jdbc by date:

Previous
From: John R Pierce
Date:
Subject: Re: Patch to allow setting schema/search_path in the connectionURL
Next
From: Tom Lane
Date:
Subject: Re: Patch to allow setting schema/search_path in the connectionURL