Re: [BUGS] BUG #8272: Unable to connect to diffrent schema from jdbc

2013-07-01 Thread John R Pierce

On 7/1/2013 12:01 AM, Heikki Linnakangas wrote:


I agree that would be a nice feature. Patches are welcome, on the 
pgsql-jdbc mailing list. As a work-around, you can set up a different 
db user for each schema, and set search_path as a per-user setting in 
the server.


or just use the default search_path, which is $USER, public... name the 
schemas same as the users...




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



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


Re: [BUGS] BUG #8272: Unable to connect to diffrent schema from jdbc

2013-07-01 Thread Heikki Linnakangas

On 01.07.2013 00:41, emes...@redhat.com wrote:

Hi
Postgres does not support currently defining the schema in teh connection
parameters which makes it imposible to seprate the database to several
schemas and connect to the right one from the application.

There is already a thread discussing that and a suggested patch that is
fixing that.
See

http://www.postgresql.org/message-id/4873f034.8010...@scharp.org


This is not a bug, but a feature request.

I agree that would be a nice feature. Patches are welcome, on the 
pgsql-jdbc mailing list. As a work-around, you can set up a different db 
user for each schema, and set search_path as a per-user setting in the 
server.


- Heikki


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #8272: Unable to connect to diffrent schema from jdbc

2013-06-30 Thread emesika
The following bug has been logged on the website:

Bug reference:  8272
Logged by:  Eli Mesika
Email address:  emes...@redhat.com
PostgreSQL version: 8.4.17
Operating system:   Linux (Fedora 18)
Description:

Hi
Postgres does not support currently defining the schema in teh connection
parameters which makes it imposible to seprate the database to several
schemas and connect to the right one from the application.


There is already a thread discussing that and a suggested patch that is
fixing that.
See


http://www.postgresql.org/message-id/4873f034.8010...@scharp.org




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs