Re: Error during "SELECT" using psycopg 2.0.2

Il giorno dom, 17/02/2008 alle 16.27 -0700, Nathan ha scritto:
> On Feb 16, 2008 10:00 AM, Federico Di Gregorio <fog-NGVKUo/i/[email protected]> wrote:
> > Are you using one connection per thread? Also, before going on make sure
> > to use an up to date psycopg, like 2.0.6.
> 
> Each thread shares a common db connection, but creates its own cursor.
>  As psycopg2.threadsafety == 2, that's supposed to be acceptable
> according to: http://www.python.org/dev/peps/pep-0249/    If the
> threadsafety level is not really 2, please let me know.

You can share connections but should take care of the ordering of the
queries because all cursors from the same connection share the same SQL
session.

> 2.0.6?  According to the psycopg project page, 2.0.2 _IS_ the latest
> version (???)  See http://www.initd.org/tracker/psycopg    ... Am I
> looking in the wrong place?

The version on the tracker is a little bit out of date. Try:

http://initd.org/pub/software/psycopg/

for the last version.

federico

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                [email protected]
INIT.D Developer                                           fog-NGVKUo/i/[email protected]
                           There's no certainty - only opportunity. -- V

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBHuMVyvcCgrgZGjesRAh+RAKC6C5WWnjSTJrRFf+RoREUL0x7hVACgiF+t
InAy81Y+E1ugEKZ0U9G1fzw=
=Modt
-----END PGP SIGNATURE-----