From: prashanth@jibe.biz
To: pgsql-interfaces@postgresql.org
Subject: Problem with Python interface with PostgreSQL 7.3
Date: Tue, 3 Dec 2002 15:40:47 -0800
Message-ID: <20021203154047.A22205@wind.jibenetworks.com> (raw)
I installed PostGreSQL 7.3 on Linux with uname -a as below:
Linux web1.jibenetworks.com 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 pgdb.py, pg.py and the pgmodule.so 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/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
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.
Thanks,
--prashanth
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: prashanth@jibe.biz
Subject: Re: Problem with Python interface with PostgreSQL 7.3
In-Reply-To: <20021203154047.A22205@wind.jibenetworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox