"Bak @ kedai" wrote:
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.
It can't worke with postgres 6.5 because it's a NEW FEATURE of postgres 7.0 :-) -- _________________________________________________________ Andreas Heckel andreas@aHIT.de