[Zope] ZSQL with different user

2005-12-19 Thread Pier Luigi Fiorini
Hello, I'm developing a Zope application that uses a PostgreSQL connection and several ZSQL objects. People should log in using a Postgres user and ZSQL object should be executed by the user that's logged in. Multiple people can be logged at the same time. Unfortunately it is not possible because

Re: [Zope] ZSQL with different user

2005-12-20 Thread Pier Luigi Fiorini
Alle 18:42, lunedì 19 dicembre 2005, hai scritto: > Pier Luigi Fiorini wrote: > > Hello, > > I'm developing a Zope application that uses a PostgreSQL connection and > > several ZSQL objects. > > People should log in using a Postgres user and ZSQL object should be

Re: [Zope] Re: ZSQL with different user

2005-12-20 Thread Pier Luigi Fiorini
> I would also be interested in multiuser ZSQLs, though it's not my main > goal and I don't expect participating on such coding. > > Provided there wont be thousands of users (mine number is just about > 20), how about to create a pool of connections in some ZODB folder, > simply identified as sqlc