Andrus wrote:
4. It is not possible to send custom commands to database server at
application startup
What kind of commands do you want to send?
I have a multi-company Postgres 8.1 database.
Each company data is stored in a separate schema named company1,
company2, etc
Common data for all companies is stored in a public schema.
At appl startup I need to specify current company using commands in
validateLogin()
cursor = self.connection.getConnection().cursor()
cursor.execute("set search_path to public,company"+companynumber )
Currenty, the only way for this is to change dbPostgresql.py file directly.
Once the dConnection object is instantiated, you should be able to:
cursor = dconnection.getDaboCursor()
cursor.superCursor.execute("set search_path...")
However, I'm not sure if this even answers your issue or if it is the
right thing to do. I'll see what Ed says.
--
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
