PerformPortalClose warning in 7.3

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

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-interfaces by date

  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

Browse pgsql-performance by date

  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