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