Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PerformPortalClose warning in 7.3

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Engelhart <mengelhart(at)mac(dot)com>
Cc: PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [GENERAL] PerformPortalClose warning in 7.3
Date: 2002-12-14 22:58:30
Message-ID: 200212142258.gBEMwUH26494@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-performance
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(at)postgresql(dot)org)
> 

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

In response to

pgsql-performance by date

Next:From: typeaDate: 2002-12-15 00:41:54
Subject: Re: ~* + LIMIT => infinite time?
Previous:From: Ron JohnsonDate: 2002-12-14 19:46:16
Subject: Re: automated index suggestor -- request for comment

pgsql-interfaces by date

Next:From: Bruce MomjianDate: 2002-12-14 23:37:01
Subject: Re: Patch for DBD::Pg pg_relcheck problem
Previous:From: Jean-Luc LachanceDate: 2002-12-13 16:42:25
Subject: Re: [PERFORM] CLUSTER command

pgsql-general by date

Next:From: Kevin BrownDate: 2002-12-15 06:02:47
Subject: Re: [HACKERS] PostgreSQL Global Development Group
Previous:From: Egyud CsabaDate: 2002-12-14 22:53:50
Subject: Re: Where are my tables physically in the fs?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group