[Zope] Re: Fwd: Re: [Zope] PoPy module

[Bak @ kedai]

On Mon, 05 Jun 2000, Thierry MICHEL wrote:
>
> > 2. Whether Auto-commit mode is on or off on ZPoPyDA  the new postgres
> > 7.0 syntax 
> >  "select * from foo limit 20 offset 10" returns all records of foo and
> > not only 20 !
> >   With PyGreSQLDA it works :-)
> 
> That's running every where, it's strange that's not running on your system.
> Do you have packed the database of Zope ? Do you have create a new object ?
>
i will vouch for this, although i'm using postgres 6.5 (from rpm).  i packed
the database,  stop and start zope.  create a zpopyda connection, and test the
connection with SQL query.  and limit doesn't work.

  
> PygresqlDA runs ok because it doesn't deal with cursors ... :-)
> 
> Thierry
> thierry@mixadlive.com
>