Re: [SECURITY] New set of PostgreSQL RPMS are available for download - Mailing list pgsql-general

From Gaetano Mendola
Subject Re: [SECURITY] New set of PostgreSQL RPMS are available for download
Date
Msg-id 417EE232.9050403@bigfoot.com
Whole thread Raw
In response to [SECURITY] New set of PostgreSQL RPMS are available for download  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-general
Devrim GUNDUZ wrote:

> * Updated PyGreSQL from 3.4 to 3.5 (only for 7.4.6-2PGDG)

Given the fact that PyGreSQL is still affected by the unfamous
"idle in transaction" behaviour:


     def __init__(self, cnx):
         self.__cnx = cnx
         self.__cache = pgdbTypeCache(cnx)
         try:
             src = self.__cnx.source()
             src.execute("BEGIN")
         except:
             raise OperationalError, "invalid connection."

     def close(self):
         self.__cnx.close()

     def commit(self):
         try:
             src = self.__cnx.source()
             src.execute("COMMIT")
             src.execute("BEGIN")
         except:
             raise OperationalError, "can't commit."

     def rollback(self):
         try:
             src = self.__cnx.source()
             src.execute("ROLLBACK")
             src.execute("BEGIN")
         except:
             raise OperationalError, "can't rollback."




why do not distribute with next RPM the psycopg instead ?



Regards
Gaetano Mendola



pgsql-general by date:

Previous
From: "Leen Besselink"
Date:
Subject: pg_autovacuum in 8beta-dev3 small bug
Next
From: Robby Russell
Date:
Subject: Re: primary key and existing unique fields