Re: [Zope] Re: Fwd: Re: [Zope] PoPy module
"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[EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Re: Fwd: Re: [Zope] PoPy module
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 > [EMAIL PROTECTED] > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Fwd: Re: [Zope] PoPy module
Thierry MICHEL wrote: ... > > 1. When I try to connect to postgres 6.4 using PoPy the connect fails > >postgres.log: ERROR: parser: parse error at or near "transaction" > > Postgres 6.4 seems not being SQL 92 compliant for the transactions ! > PoPy is ! pygresql no certtainly ! OK ... take it as a note for users still working with postgres 6.4 ;-) > > 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 ? > > PygresqlDA runs ok because it doesn't deal with cursors ... :-) I of course I packed the Zope database several times. But after I installed PoPy I did not pack it. I only created a Z PoPy Database connection and a Z SQL Method to test the DA. Please reply if I can help you with some logs or version info of my system. -- _ Andreas Heckel[EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN ;-) ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: Fwd: Re: [Zope] PoPy module
On Mon, Jun 05, 2000 at 10:25:20AM +0200, [EMAIL PROTECTED] wrote: > > > -- Forwarded message -- > Da: jani <[EMAIL PROTECTED]> > Soggetto: Re: [Zope] PoPy module > Data: Sun, 04 Jun 2000 20:14:03 -0700 >A: Alexander N Gould <[EMAIL PROTECTED]> >Copia: [EMAIL PROTECTED] > > Alexander N Gould wrote: > > > > I'm trying to install the PoPy Python module on my Yellowdog Linux system > > (a redhat clone for PowerPC hardware). I'm sure it's a simple task, but I > > don't know how to do it. Any suggestions or tips? Thanks in advance. > > > > Building highways to reduce traffic is like loosening your belt to reduce > > obesity > > First make sure that pyton-devel is installed on your system. > It's available at www.python.org I think. > > Untar PoPy-1.1.tar.gz and ZPoPyDA-0.3.tar.gz . > First you have to build PoPy. > On my system I had to modify the lib and include path in Setup and > in PoPymodule.c > > Setup: > *shared* > PoPy PoPymodule.c -I/usr/local/pgsql/include -L/usr/local/pgsql/lib -lpr > > PoPymodule.c: > ... > #include > #include > ... > > Go on with: > make -f Makefile.pre.in boot > make > > You should now have the shared library PoPymodule.so . > Copy this file to python1.5/site-packages on your system. With make install, it compiles and installs directly in the python1.5/site-packages. > Now you have to install zope-popyda-0.3 > "make install" will place the Zope product to > /usr/lib/zope/lib/python/Products/ZPoPyDA > > Just move it to the Product folder of your Zope installation. > Restart Zope and it should work ;-) > > Take a look at the README. It describes the format of the connection > string. > It's different from that of PyGreSQLDA! > Also make sure that you hav set proper permissions on > &PGDATA/pg_hba.conf > > BTW after i recognized some problems using PoPy I switched back to > PyGreSQLDA. > 1. When I try to connect to postgres 6.4 using PoPy the connect fails >postgres.log: ERROR: parser: parse error at or near "transaction" Postgres 6.4 seems not being SQL 92 compliant for the transactions ! PoPy is ! pygresql no certtainly ! > 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 ? PygresqlDA runs ok because it doesn't deal with cursors ... :-) Thierry [EMAIL PROTECTED] > -- > _ > Andreas Heckel[EMAIL PROTECTED] > > ___ > Zope maillist - [EMAIL PROTECTED] > http://lists.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://lists.zope.org/mailman/listinfo/zope-announce > http://lists.zope.org/mailman/listinfo/zope-dev ) > > > ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )