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_stat_activity;" (outside of web2py) and I see 97 
rows that show connections to each of the databases in my list up to the 
one that errored out.
 
The reason for the SELECT * FROM information_schema.tables is to make sure 
the "summary" table exists in the legacy database before attempting to 
query the "summary" table.

-- 

--- 
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to