Re: [GENERAL] RESET ROLE and search_path, Connection pool

2010-12-05 Thread Marc Mamin
rc Mamin Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] RESET ROLE and search_path, Connection pool On Fri, Dec 3, 2010 at 5:13 AM, Marc Mamin wrote: Hello, We are thinking about using a (java based) connection pool. An issue is that there are many different users to connect. My idea is to o

Re: [GENERAL] RESET ROLE and search_path, Connection pool

2010-12-03 Thread Derrick Rice
On Fri, Dec 3, 2010 at 5:13 AM, Marc Mamin wrote: > Hello, > > We are thinking about using a (java based) connection pool. > An issue is that there are many different users to connect. > My idea is to only have superuser connections in the pool > and change the connection role (with SET ROLE) eac