Re: [Pypgsql-users] typprtlen

[Gerhard <ger...@gm...>]

* Oliver Vecernik <vec...@ao...> [2003-01-09 09:43 +0100]:
> Hi!
> 
> I tried to use PgSQL on Debian/Woody and received following error:
> 
> Python 2.1.3 (#1, Sep  7 2002, 15:29:56)
> [GCC 2.95.4 20011002 (Debian prerelease)] on linux2
> Type "copyright", "credits" or "license" for more information.
> >>> from pyPgSQL import PgSQL
> >>> cx = PgSQL.connect('p200::test')
> >>> cu = cx.cursor()
> >>> cu.execute("select * from t1")
> Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
>   File "/usr/lib/python2.1/site-packages/pyPgSQL/PgSQL.py", line 2157, 
> in execute
>     self.__makedesc__()
>   File "/usr/lib/python2.1/site-packages/pyPgSQL/PgSQL.py", line 1892, 
> in __makedesc__
>     _tn, _pl, _ia, _bt = _cache.getTypeInfo(_typ)
>   File "/usr/lib/python2.1/site-packages/pyPgSQL/PgSQL.py", line 576, 
> in getTypeInfo
>     _res = self.__conn.conn.query("SELECT typname, typprtlen, typelem "
> libpq.OperationalError: ERROR:  Attribute "typprtlen" not found
> 
> >>>
> 
> 
> ii  python-pgsql   2.0-3.1        A Python DB-API 2.0 interface to 
> PostgreSQL
> 
> Am I doing something wrong, or is this a broken package in Debian?

You're using pyPgSQL against a PostgreSQL 7.3.x database. pyPgSQL,
however, supports a Pg 7.3 backend only in the latest released version
(pyPgSQL 2.3).

So, for the moment you need to compile pyPgSQL yourself, as even the
Debian unstable package seems to still be a 2.3-beta1.

If you want to do a quick hack in your pyPgSQL 2.0 package instead, you
can try to change the typprtlen field in the select to NULL.

Gerhard
-- 
Favourite database:             http://www.postgresql.org/
Favourite programming language: http://www.python.org/
Combine the two:                http://pypgsql.sf.net/
Embedded database for Python:   http://pysqlite.sf.net/