Re: [GENERAL] PerformPortalClose warning in 7.3

I tried to reproduce the problem here but it seems my python is too old.
I am CC'ing this to the interfaces list in case someone there knows or
can test it.

---------------------------------------------------------------------------

Michael Engelhart wrote:
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073