postgresql-7.3rc2 python interface fails

Started by George Youngover 23 years ago1 messagesbugs
Jump to latest
#1George Young
gry@ll.mit.edu

[SuSE Linux 8.0, Postgresql-7.3rc2, gcc-3.2, python 2.2.1]
[using PyGresql v3.3 from the 7.3rc2 distribution]

Postgres install goes fine as a fresh install. Psql access is fine.
Pgdb (the python interface) cursor.execute fails on any query; it asks for "pg_type.typprtlen",
which has apparently been deleted from postgresql 7.3:
http://archives.postgresql.org/pgsql-hackers/2002-07/msg00577.php

sty:> python
Python 2.2.1 (#1, Sep 25 2002, 17:25:00)
[GCC 3.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.

import pgdb
db=pgdb.connect(host='localhost',database='template1')
cur=db.cursor()
cur.execute('select * from pg_class')

Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "/usr/local/lib/python2.2/site-packages/pgdb.py", line 189, in execute
self.executemany(operation, (params,))
File "/usr/local/lib/python2.2/site-packages/pgdb.py", line 221, in executemany
desc = typ[1:2]+self.__cache.getdescr(typ[2])
File "/usr/local/lib/python2.2/site-packages/pgdb.py", line 149, in getdescr
self.__source.execute(
_pg.error: ERROR: Attribute "typprtlen" not found

From the postgres log, the offending query was:
SELECT typname, typprtlen, typlen FROM pg_type WHERE oid = 19

What was typprtlen supposed to mean?

Most of my postgres applications are written in python -- I *have* to have
a working python interface...

Problem also exists in PyGreSQL-3.4-pre020320.

-- George

George Young, Rm. L-204 gry at ll.mit.edu
MIT Lincoln Laboratory
244 Wood St.
Lexington, Massachusetts 02420-9108 (781) 981-2756

SCSI is not magic. There are fundamental technical reasons why it
is necessary to sacrifice a young goat to your SCSI chain now and
then.