Skip site navigation (1) Skip section navigation (2)

Problem with Python interface with PostgreSQL 7.3

From: prashanth(at)jibe(dot)biz
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Problem with Python interface with PostgreSQL 7.3
Date: 2002-12-03 23:40:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I installed PostGreSQL 7.3 on Linux with uname -a as below:
Linux 2.4.18-3 #1 Thu Apr 18 07:32:41 EDT 2002 i686 unknown 

make check passed all tests.

I also have Python 2.2.2 installed:

Python 2.2.2 (#1, Nov 18 2002, 14:41:56)
[GCC 2.96 20000731 (Red Hat Linux 7.3 2.96-110)] on linux2

The, and the have been correctly installed 
into the python2.2 site-packages directory.

However, a basic query fails with the following error:

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

The postmaster logs show the following:

bash-2.05a$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
LOG:  database system was shut down at 2002-12-03 16:30:33 PST
LOG:  checkpoint record is at 0/A5730C
LOG:  redo record is at 0/A5730C; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 1023; next oid: 19422
LOG:  database system is ready
ERROR:  Attribute "typprtlen" not found

Is this a bug, or a misconfigured installation?

Pointers would be helpful.



pgsql-interfaces by date

Next:From: Bruce BadgerDate: 2002-12-04 01:54:29
Subject: Multibyte characters over the frontend/backend protocol
Previous:From: Jeroen T. VermeulenDate: 2002-12-03 20:27:36
Subject: Re: libpqxx testers needed!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group