From: | Michael Engelhart <mengelhart(at)mac(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PerformPortalClose warning in 7.3 |
Date: | 2002-12-12 22:50:55 |
Message-ID: | 2C6CDB6A-0E24-11D7-8E88-000393A48A3C@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | johnnnnnn | 2002-12-12 23:00:02 | Re: [GENERAL] CLUSTER command |
Previous Message | Lincoln Yeoh | 2002-12-12 22:49:12 | Re: CLUSTER command |
From | Date | Subject | |
---|---|---|---|
Next Message | johnnnnnn | 2002-12-12 23:00:02 | Re: [GENERAL] CLUSTER command |
Previous Message | Lincoln Yeoh | 2002-12-12 22:49:12 | Re: CLUSTER command |
From | Date | Subject | |
---|---|---|---|
Next Message | johnnnnnn | 2002-12-12 23:00:02 | Re: [GENERAL] CLUSTER command |
Previous Message | Lincoln Yeoh | 2002-12-12 22:49:12 | Re: CLUSTER command |