PerformPortalClose warning in 7.3
Michael Engelhart <mengelhart@mac.com>
From: Michael Engelhart <mengelhart@mac.com>
To: pgsql-general@postgresql.org
Date: 2002-12-12T22:50:55Z
Lists: pgsql-performance, pgsql-general
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