[Zope] ZSQL database connection (ZPoPy) not giving expected results

Ok, here's the situation. I create a folderish object. I insert some info into the postgresql database related to this folderish object. I create a ZPopy database connection within this folderish object. All of this is done through a python method. If I do a query using this new database connection, select for rows I just inserted. The query comes back with no results. I can do this query using another ZSQL DB connection, and on the command line, it works fine. Caching is off for the query. Eventually, after 30 seconds to 4 minutes, all queries seem to work fine. This behavior is inconsistent, sometimes the queries work after no wait at all. Any ideas?