Python client lib for PostgreSQL8

[Peter Maas]

I just tried to connect to a PostgreSQL8 beta2 database server with
pyPgSQL 2.4 and got a libpq.DatabaseE rror telling "Ivalid format for
PgVersion construction".

Is there already a PyPgSQL version in CVS or another client library
that handles PostgreSQL 8?

--
-------------------------------------------------------------------
Peter Maas, M+R Infosysteme, D-52070 Aachen, Tel [phone]
E-mail 'cGV0ZXIubWFhc0 BtcGx1c3IuZGU=\ n'.decode('base 64')
-------------------------------------------------------------------

[Gerhard Haering]

On Thu, Nov 18, 2004 at 01:58:48PM +0100, Peter Maas wrote:

I just tried to connect to a PostgreSQL8 beta2 database server with
pyPgSQL 2.4 and got a libpq.DatabaseE rror telling "Ivalid format for
PgVersion construction".

Is there already a PyPgSQL version in CVS or another client library
that handles PostgreSQL 8?

Oh, I wanted to fix that since some time ago.

Attached is a quick, completely untested try. If it doesn't work like this,you
should get the idea how to make it work ;-)

-- Gerhard

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

iD8DBQFBnKlHdIO 4ozGCH14RAiLTAJ 4vuRpjlBYiKe7K3 w5hSNdqz92CvgCe N8ty
nMWLDmkwA6j2dV8 3b0+Q18I=
=hSiu
-----END PGP SIGNATURE-----

[Michael Fuhr]

Peter Maas <pe***@somewher e.com> writes:

I just tried to connect to a PostgreSQL8 beta2 database server with
pyPgSQL 2.4 and got a libpq.DatabaseE rror telling "Ivalid format for
PgVersion construction".
This bug was reported over three months ago:

http://sourceforge.net/tracker/index...28&atid=116528
Is there already a PyPgSQL version in CVS or another client library
that handles PostgreSQL 8?

A lot of people like psycopg.

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

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

[Peter Maas]

Gerhard Haering schrieb:

On Thu, Nov 18, 2004 at 01:58:48PM +0100, Peter Maas wrote:

I just tried to connect to a PostgreSQL8 beta2 database server with
pyPgSQL 2.4 and got a libpq.DatabaseE rror telling "Ivalid format for
PgVersion construction".

[...] Attached is a quick, completely untested try. If it doesn't work like this, you
should get the idea how to make it work ;-)

Thanks, Gerhard, but it doesn't work.

The error is due to pgversion.c/parseToken(). Parsing the vstr info
into major, minor, patch doesn't work. The version string from
"SELECT version();" is

PostgreSQL 8.0.0beta4 on ...

parseToken() handles beta versions too restrictive allowing only ...b4
instead of ...beta4. I have relaxed this condition by replacing the line

*result = strtol(token, &last, 0);

by

*result = strtol(token, &last, 0);
return (errno != 0);

thus allowing everything after the patch number. This is perhaps
too permissive but my test script with a simple SELECT statement
works now.

--
-------------------------------------------------------------------
Peter Maas, M+R Infosysteme, D-52070 Aachen, Tel [phone]
E-mail 'cGV0ZXIubWFhc0 BtcGx1c3IuZGU=\ n'.decode('base 64')
-------------------------------------------------------------------

[Peter Maas]

Michael Fuhr schrieb:

Is there already a PyPgSQL version in CVS or another client library
that handles PostgreSQL 8?

A lot of people like psycopg.

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

Thanks, Michael. Does it handle PostgreSQL 8beta? I didn't try psycopg
yet because I used to work at a Win2k computer and wasn't able to
compile it. C++Builder didn't work and I was not in the mood to buy
MSVC for compiling Python extensions).

Now I've made the jump to a Linux workstation but I still prefer
software that I can install on several platforms without hassle.
I don't have any clue what advantages psycopg has over pyPgSQL.
Are there comparisons / benchmarks available?

--
-------------------------------------------------------------------
Peter Maas, M+R Infosysteme, D-52070 Aachen, Tel [phone]
E-mail 'cGV0ZXIubWFhc0 BtcGx1c3IuZGU=\ n'.decode('base 64')
-------------------------------------------------------------------

[Michael Fuhr]

Peter Maas <pe***@somewher e.com> writes:

Michael Fuhr schrieb:

Is there already a PyPgSQL version in CVS or another client library
that handles PostgreSQL 8?
A lot of people like psycopg.

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

Thanks, Michael. Does it handle PostgreSQL 8beta?

Yes -- I use psycopg with the PostgreSQL 8.0 betas.
Now I've made the jump to a Linux workstation but I still prefer
software that I can install on several platforms without hassle.
I don't have any clue what advantages psycopg has over pyPgSQL.
Are there comparisons / benchmarks available?

Psycopg can be a lot faster than pyPgSQL or PyGreSQL, especially
when retrieving large data sets. You could google for comparisons,
but the most meaningful benchmarks would be those that you ran
against your own data.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/