[Zope-DB] Re: ZPsycopgDA (version 1.0.13) problems

[Dieter Maurer]

Federico Di Gregorio wrote at 2003-1-20 14:25 +0100:
 > >   *  "max_rows==0" is interpreted as to not return results at all.
 > >      It seems more consistent with other use of the value "0"
 > >      to interpret it as "no restriction"
 > 
 > ok. i'll just make sure zope does not assign a different meaning to 0.
Other DA's (e.g. "ZMySQLDA") interpret "0" as "no limitation".
The same interpretation is used in Zope session implementation.

Interpreting "0" as "do not return any results" is not useful.

 > ...
 > >   *  I have been unable to understand the motivation for the "failure"
 > >      use in "db.DA.query".
 > 
 > if a generic (not catched) error happens, we try to close and reopen the
 > connection a number of times before returning an error. this code was
 > copied from ZOracle and i never been completely satisfacted by it.
That would seem reasonable...

But the code looks different:

    you fail 1000 times, then you close/reopen and try again.

 > > Besides, we still have a problem not yet understood:
 > > 
 > >    Sometimes, we seem to get empty result sets from Postgres (where we know,
 > >    the result set should be non-empty).
 > >    We are still investigating this problem.
 > 
 > good. if you want my help, just send me any relevant code and data to
 > reproduce the problem.
Thank you for the offer.

However, the problem happens non-deterministically; we cannot yet
reproduce it.
I will let you know when we know more...


Dieter