Postgres Pro
Downloads
Home   >   mailing lists

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

From stagirus
Subject Re: Patch to allow setting schema/search_path in the connectionURL
Date
Msg-id 1411447985623-5820021.post@n5.nabble.com
Whole thread Raw
In response to Re: Patch to allow setting schema/search_path in the connectionURL  (cowwoc <cowwoc@bbs.darktech.org>)
Responses Re: Patch to allow setting schema/search_path in the connectionURL
List pgsql-jdbc
Tree view 
I just tried as follows:
ALTER ROLE dev SET search_path TO bep;

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.



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Patch-to-allow-setting-schema-search-path-in-the-connectionURL-tp2174512p5820021.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

pgsql-jdbc by date:

Previous
From: "Lussier, Denis"
Date:
Subject: Re: Disk buffering of resultsets
Next
From: stagirus
Date:
Subject: Re: Patch to allow setting schema/search_path in the connectionURL