From: Michael Engelhart <mengelhart@mac.com>
To: pgsql-general@postgresql.org
Subject: PerformPortalClose warning in 7.3
Date: Thu, 12 Dec 2002 17:50:55 -0500
Message-ID: <2C6CDB6A-0E24-11D7-8E88-000393A48A3C@mac.com> (raw)
In-Reply-To: <3DF91030.A372DF7C@nsd.ca>
Hi -
I've been running PostgreSQL 7.3 on Mac OS X 10.2 since it was released
and it's been running fine. I'm using pyPgSQL 2.3 for client side
programming which also was working great until tonight. Now whenever
I do any query of any type, I get warnings like this:
WARNING: PerformPortalClose: portal "pgsql_00179f10" not found
It "appears" that everything is still working the way it was but it's a
bit discomforting to have these show up on my screen while running my
applications.
Anyone that can explain this?
Here's a tiny bit of Python sample code that I used to make sure it
wasn't my other code causing the problems
from pyPgSQL import PgSQL
dbname = "template1"
conn = PgSQL.connect(database=dbname)
cursor = conn.cursor()
sql = "SELECT now()";
cursor.execute(sql)
res = cursor.fetchall()
for i in res:
print i
cursor.close()
conn.commit()
strangely if I remove the last 2 lines (cursor.close() and
conn.commit()) I don't get the errors.
Also I don't notice that I don't have this problem with psql command
line either. Is this the Python API causing this?
Thanks for any help
Mike
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: mengelhart@mac.com, pgsql-general@postgresql.org
Subject: Re: PerformPortalClose warning in 7.3
In-Reply-To: <2C6CDB6A-0E24-11D7-8E88-000393A48A3C@mac.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