Re: v 2.3 warning messages

*** pyPgSQL/PgSQL.py	14 Dec 2002 05:13:34 -0000	1.29
--- pyPgSQL/PgSQL.py	23 Dec 2002 05:40:19 -0000
***************
*** 2638,2644 ****
  	try:
  	    if (self.closed == 0) and self.conn.inTransaction:
  		try:
! 		    self.conn.conn.query("CLOSE %s" % self.name)
  		except:
  		    pass
  	except:
--- 2638,2644 ----
  	try:
  	    if (self.closed == 0) and self.conn.inTransaction:
  		try:
! 		    self.conn.conn.query('CLOSE "%s"' % self.name)
  		except:
  		    pass
  	except:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Content-Type: multipart/mixed ;
	boundary="==_Exmh_7371093640"

This is a multipart MIME message.

- --==_Exmh_7371093640
Content-Type: text/plain; charset=us-ascii

Michael Engelhart wrote:
> Hi -
> i'm running pyPgSQL 2.3 on Mac OS X 10.2.2, PostgreSQL 7.3, and  Python 
> 2.2
> 
> When doing any SELECT, UPDATE, INSERT or DELETE operations on the 
> database I get the following database warning errors:
> 
> WARNING:  PerformPortalClose: portal "pgsql_0061be10" not found
> WARNING:  Closing pre-existing portal "PgSQL_0061BE10"
> WARNING:  PerformPortalClose: portal "pgsql_0061be10" not found
> WARNING:  PerformPortalClose: portal "pgsql_006e0460" not found
> 
> 
> These do not occur when I access the database using the psql CLI 
> application.
> 
> Everything appears to work as it should even with these warnings but 
> they certainly are preventing me from releasing a production system 
> until I can figure out what is causing this.
> 
> I have already posted this to postgresql-general but Bruce Mojiam 
> seemed to think it was related to the Python interface since he was 
> unable to make it occur with any of the other Python interfaces.
> 
> Any ideas?

Here is the patch to correct the problem.  CVS will be updated shortly.


- --==_Exmh_7371093640
Content-Type: text/plain ; name="patch.20021223"; charset=us-ascii
Content-Description: patch.20021223
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="patch.20021223"

KioqIHB5UGdTUUwvUGdTUUwucHkJMTQgRGVjIDIwMDIgMDU6MTM6MzQgLTAwMDAJMS4yOQot
LS0gcHlQZ1NRTC9QZ1NRTC5weQkyMyBEZWMgMjAwMiAwNTo0MDoxOSAtMDAwMAoqKioqKioq
KioqKioqKioKKioqIDI2MzgsMjY0NCAqKioqCiAgCXRyeToKICAJICAgIGlmIChzZWxmLmNs
b3NlZCA9PSAwKSBhbmQgc2VsZi5jb25uLmluVHJhbnNhY3Rpb246CiAgCQl0cnk6CiEgCQkg
ICAgc2VsZi5jb25uLmNvbm4ucXVlcnkoIkNMT1NFICVzIiAlIHNlbGYubmFtZSkKICAJCWV4
Y2VwdDoKICAJCSAgICBwYXNzCiAgCWV4Y2VwdDoKLS0tIDI2MzgsMjY0NCAtLS0tCiAgCXRy
eToKICAJICAgIGlmIChzZWxmLmNsb3NlZCA9PSAwKSBhbmQgc2VsZi5jb25uLmluVHJhbnNh
Y3Rpb246CiAgCQl0cnk6CiEgCQkgICAgc2VsZi5jb25uLmNvbm4ucXVlcnkoJ0NMT1NFICIl
cyInICUgc2VsZi5uYW1lKQogIAkJZXhjZXB0OgogIAkJICAgIHBhc3MKICAJZXhjZXB0Ogo=

- --==_Exmh_7371093640
Content-Type: text/plain; charset=us-ascii

____       | Billy G. Allie    | Domain....: [email protected]
|  /|      | 7436 Hartwell     | MSN.......: [email protected]
|-/-|----- | Dearborn, MI 48126|
|/  |LLIE  | (313) 582-1540    |

- --==_Exmh_7371093640--


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.2 (UnixWare)
Comment: Exmh version 2.2 06/23/2000

iD8DBQE+BqI0nmIkMXoVVdURAgteAJ95cHHEUE4Qva1TuQyTDElG2MPvewCfZmkc
Dcz6RnGq8A0vnF/tfMvVOMM=
=P/Wn
-----END PGP SIGNATURE-----