[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-21 Thread ewong1111
I changed the DAL pool_size to 0 and then my_db.close() did what I wanted. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-20 Thread ewong1111
Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_s

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-20 Thread ewong1111
Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_st

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-20 Thread Massimo Di Pierro
Where is this code? If it is in a web2py model or controller you do not need to close. If it is a a script that you run with web2py.py ... -R script.py than you need to close it. You should close it with my_db.commit() What is the reason for this? res = my_db.executesql("SELECT * FROM inf