psycopg2

What's new in psycopg 2.9.11
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

• Add support for Python 3.14.
• Avoid a segfault passing more arguments than placeholders if Python is built
  with assertions enabled (:ticket:#1791).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to
  PostgreSQL 18.
• Drop support for Python 3.8.

What's new in psycopg 2.9.10
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

• Add support for Python 3.13.
• Receive notifications on commit (:ticket:#1728).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to
  PostgreSQL 17.
• Drop support for Python 3.7.

• Add support for Python 3.12.
• Drop support for Python 3.6.

• Wheel package bundled with PostgreSQL 16 libpq in order to add support for
  recent features, such as sslcertmode.

• Fix propagation of exceptions raised during module initialization
  (:ticket:#1598).
• Fix building when pg_config returns an empty string (:ticket:#1599).
• Wheel package compiled against OpenSSL 1.1.1v.

• Package manylinux 2014 for aarch64 and ppc64le platforms, in order to
  include libpq 15 in the binary package (:ticket:#1396).
• Wheel package compiled against OpenSSL 1.1.1t.

What's new in psycopg 2.9.5
^^^^^^^^^^^^^^^^^^^^^^^^^^^

• Add support for Python 3.11.
• Add support for rowcount in MERGE statements in binary packages
  (:ticket:#1497).
• Wheel package compiled against OpenSSL 1.1.1r and PostgreSQL 15 libpq.

What's new in psycopg 2.9.4
^^^^^^^^^^^^^^^^^^^^^^^^^^^

• Fix ~psycopg2.extras.register_composite(),
  ~psycopg2.extras.register_range() with customized search_path
  (:ticket:#1487).
• Handle correctly composite types with names or in schemas requiring escape.
• Find pg_service.conf file in the /etc/postgresql-common`` directory in
  binary packages (:ticket:1365).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to
  PostgreSQL 15.
• Wheel package compiled against OpenSSL 1.1.1q and PostgreSQL 14.4

• Alpine (musl) wheels now available (:ticket:#1392).
• macOS arm64 (Apple M1) wheels now available (:ticket:1482).

• Raise ValueError for dates >= Y10k (:ticket:#1307).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to PostgreSQL 14.
• Add preliminary support for Python 3.11 (:tickets:#1376, #1386).
• Wheel package bundled with OpenSSL 1.1.1l and PostgreSQL 14.1 libpq (:ticket:#1388).

• Fix regression with named ~psycopg2.sql.Placeholder (:ticket:#1291).

What's new in psycopg 2.9

• with connection starts a transaction on autocommit transactions too (:ticket:#941).
• Timezones with fractional minutes are supported on Python 3.7 and following (:ticket:#1272).
• Escape table and column names in ~cursor.copy_from() and ~cursor.copy_to().
• Connection exceptions with sqlstate 08XXX reclassified as ~psycopg2.OperationalError (a subclass of the previously used ~psycopg2.DatabaseError) (:ticket:#1148).
• Include library dirs required from libpq to work around MacOS build problems (:ticket:#1200).

Other changes:

• Dropped support for Python 2.7, 3.4, 3.5 (:tickets:#1198, #1000, #1197).
• Dropped support for mx.DateTime.
• Use datetime.timezone objects by default in datetime objects instead of ~psycopg2.tz.FixedOffsetTimezone.
• The psycopg2.tz module is deprecated and scheduled to be dropped in the next major release.
• Provide :pep:599 wheels packages (manylinux2014 tag) for i686 and x86_64 platforms.
• Provide :pep:600 wheels packages (manylinux_2_24 tag) for aarch64 and ppc64le platforms.
• Wheel package bundled with OpenSSL 1.1.1k and PostgreSQL 13.3 libpq.
• Build system for Linux/MacOS binary packages moved to GitHub Actions.

• Fixed memory leak changing connection encoding to the current one (:ticket:#1101).
• Fixed search of mxDateTime headers in virtualenvs (:ticket:#996).
• Added missing values from errorcodes (:ticket:#1133).
• cursor.query reports the query of the last :sql:COPY operation too (:ticket:#1141).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to PostgreSQL 13.
• Added wheel packages for ARM architecture (:ticket:#1125).
• Wheel package bundled with OpenSSL 1.1.1g.

• Fixed use of !connection_factory and !cursor_factory together (:ticket:#1019).
• Added support for ~logging.LoggerAdapter in ~psycopg2.extras.LoggingConnection (:ticket:#1026).
• ~psycopg2.extensions.Column objects in cursor.description can be sliced (:ticket:#1034).
• Added AIX support (:ticket:#1061).
• Fixed ~copy.copy() of ~psycopg2.extras.DictCursor rows (:ticket:#1073).

• Fixed building with Python 3.8 (:ticket:#854).
• Don't swallow keyboard interrupts on connect when a password is specified in the connection string (:ticket:#898).
• Don't advance replication cursor when the message wasn't confirmed (:ticket:#940).
• Fixed inclusion of time.h on linux (:ticket:#951).
• Fixed int overflow for large values in ~psycopg2.extensions.Column.table_oid and ~psycopg2.extensions.Column.type_code (:ticket:#961).
• ~psycopg2.errorcodes map and ~psycopg2.errors classes updated to PostgreSQL 12.
• Wheel package bundled with OpenSSL 1.1.1d and PostgreSQL at least 11.4.

• Added interval_status parameter to ~psycopg2.extras.ReplicationCursor.start_replication() method and other facilities to send automatic replication keepalives at periodic intervals (:ticket:#913).
• Fixed namedtuples caching introduced in 2.8 (:ticket:#928).

• Fixed ~psycopg2.extras.RealDictCursor when there are repeated columns (:ticket:#884).
• Binary packages built with openssl 1.1.1b. Should fix concurrency problems (:tickets:#543, #836).

• Fixed ~psycopg2.extras.RealDictRow modifiability (:ticket:#886).
• Fixed "there's no async cursor" error polling a connection with no cursor (:ticket:#887).

What's new in psycopg 2.8

New features:

• Added ~psycopg2.errors module. Every PostgreSQL error is converted into a specific exception class (:ticket:#682).
• Added ~psycopg2.extensions.encrypt_password() function (:ticket:#576).
• Added ~psycopg2.extensions.BYTES adapter to manage databases with mixed encodings on Python 3 (:ticket:#835).
• Added ~psycopg2.extensions.Column.table_oid and ~psycopg2.extensions.Column.table_column attributes on cursor.description items (:ticket:#661).
• Added connection.info object to retrieve various PostgreSQL connection information (:ticket:#726).
• Added ~connection.get_native_connection() to expose the raw PGconn structure to C extensions via Capsule (:ticket:#782).
• Added ~connection.pgconn_ptr and ~cursor.pgresult_ptr to expose raw C structures to Python and interact with libpq via ctypes (:ticket:#782).
• ~psycopg2.sql.Identifier can represent qualified names in SQL composition (:ticket:#732).
• Added !ReplicationCursor.\ ~psycopg2.extras.ReplicationCursor.wal_end attribute (:ticket:#800).
• Added fetch parameter to ~psycopg2.extras.execute_values() function (:ticket:#813).
• !str() on ~psycopg2.extras.Range produces a human-readable representation (:ticket:#773).
• ~psycopg2.extras.DictCursor and ~psycopg2.extras.RealDictCursor rows maintain columns order (:ticket:#177).
• Added ~psycopg2.extensions.Diagnostics.severity_nonlocalized attribute on the ~psycopg2.extensions.Diagnostics object (:ticket:#783).
• More efficient ~psycopg2.extras.NamedTupleCursor (:ticket:#838).

Bug fixes:

• Fixed connections occasionally broken by the unrelated use of the multiprocessing module (:ticket:#829).
• Fixed async communication blocking if results are returned in different chunks, e.g. with notices interspersed to the results (:ticket:#856).
• Fixed adaptation of numeric subclasses such as ~enum.IntEnum (:ticket:#591).

Other changes:

• Dropped support for Python 2.6, 3.2, 3.3.
• Dropped psycopg1 module.
• Dropped deprecated !register_tstz_w_secs() (was previously a no-op).
• Dropped deprecated !PersistentConnectionPool. This pool class was mostly designed to interact with Zope. Use !ZPsycopgDA.pool instead.
• Binary packages no longer installed by default. The 'psycopg2-binary' package must be used explicitly.
• Dropped !PSYCOPG_DISPLAY_SIZE build parameter.
• Dropped support for mxDateTime as the default date and time adapter. mxDatetime support continues to be available as an alternative to Python's builtin datetime.
• No longer use 2to3 during installation for Python 2 & 3 compatibility. All source files are now compatible with Python 2 & 3 as is.
• The !psycopg2.test package is no longer installed by python setup.py install.
• Wheel package bundled with OpenSSL 1.0.2r and PostgreSQL 11.2 libpq.

• Cleanup of the cursor results assignment code, which might have solved double free and inconsistencies in concurrent usage (:tickets:#346, #384).
• Wheel package bundled with OpenSSL 1.0.2q.

• Fixed binary package broken on OS X 10.12 (:ticket:#807).
• Wheel package bundled with PostgreSQL 11.1 libpq.

• Close named cursors if exist, even if ~cursor.execute() wasn't called (:ticket:#746).
• Fixed building on modern FreeBSD versions with Python 3.7 (:ticket:#755).
• Fixed hang trying to :sql:COPY via ~cursor.execute() in asynchronous connections (:ticket:#781).
• Fixed adaptation of arrays of empty arrays (:ticket:#788).
• Fixed segfault accessing the connection's ~connection.readonly and ~connection.deferrable attributes repeatedly (:ticket:#790).
• ~psycopg2.extras.execute_values() accepts ~psycopg2.sql.Composable objects (:ticket:#794).
• ~psycopg2.errorcodes map updated to PostgreSQL 11.
• Wheel package bundled with PostgreSQL 10.5 libpq and OpenSSL 1.0.2p.

• Allow non-ascii chars in namedtuple fields (regression introduced fixing :ticket:#211).
• Fixed adaptation of arrays of arrays of nulls (:ticket:#325).
• Fixed building on Solaris 11 and derivatives such as SmartOS and illumos (:ticket:#677).
• Maybe fixed building on MSYS2 (as reported in :ticket:#658).
• Allow string subclasses in connection and other places (:ticket:#679).
• Don't raise an exception closing an unused named cursor (:ticket:#716).
• Wheel package bundled with PostgreSQL 10.4 libpq and OpenSSL 1.0.2o.

• Moving away from installing the wheel package by default. Packages installed from wheel raise a warning on import. Added package psycopg2-binary to install from wheel instead (:ticket:#543).
• Convert fields names into valid Python identifiers in ~psycopg2.extras.NamedTupleCursor (:ticket:#211).
• Fixed Solaris 10 support (:ticket:#532).
• cursor.mogrify() can be called on closed cursors (:ticket:#579).
• Fixed setting session characteristics in corner cases on autocommit connections (:ticket:#580).
• Fixed ~psycopg2.extras.MinTimeLoggingCursor on Python 3 (:ticket:#609).
• Fixed parsing of array of points as floats (:ticket:#613).
• Fixed ~psycopg2.__libpq_version__ building with libpq >= 10.1 (:ticket:#632).
• Fixed ~cursor.rowcount after ~cursor.executemany() with :sql:RETURNING statements (:ticket:#633).
• Fixed compatibility problem with pypy3 (:ticket:#649).
• Wheel packages bundled with PostgreSQL 10.1 libpq and OpenSSL 1.0.2n.
• Wheel packages for Python 2.6 no more available (support dropped from wheel building infrastructure).

• Wheel package bundled with PostgreSQL 10.0 libpq and OpenSSL 1.0.2l (:tickets:#601, #602).

• Dropped libresolv from wheel package to avoid incompatibility with glibc 2.26 (wheels ticket #2).

• Restored default :sql:timestamptz[] typecasting to Python !datetime. Regression introduced in Psycopg 2.7.2 (:ticket:#578).

• Fixed inconsistent state in externally closed connections (:tickets:#263, #311, #443). Was fixed in 2.6.2 but not included in 2.7 by mistake.
• Fixed Python exceptions propagation in green callback (:ticket:#410).
• Don't display the password in connection.dsn when the connection string is specified as an URI (:ticket:#528).
• Return objects with timezone parsing "infinity" :sql:timestamptz (:ticket:#536).
• Dropped dependency on VC9 runtime on Windows binary packages (:ticket:#541).
• Fixed segfault in ~connection.lobject() when mode=\ !None (:ticket:#544).
• Fixed ~connection.lobject() keyword argument lobject_factory (:ticket:#545).
• Fixed ~psycopg2.extras.ReplicationCursor.consume_stream() keepalive_interval argument (:ticket:#547).
• Maybe fixed random import error on Python 3.6 in multiprocess environment (:ticket:#550).
• Fixed random !SystemError upon receiving abort signal (:ticket:#551).
• Accept ~psycopg2.sql.Composable objects in ~psycopg2.extras.ReplicationCursor.start_replication_expert() (:ticket:#554).
• Parse intervals returned as microseconds from Redshift (:ticket:#558).
• Added ~psycopg2.extras.Json !prepare() method to consider connection params when adapting (:ticket:#562).
• ~psycopg2.errorcodes map updated to PostgreSQL 10 beta 1.

• Ignore !None arguments passed to ~psycopg2.connect() and ~psycopg2.extensions.make_dsn() (#517).

• OpenSSL upgraded from major version 0.9.8 to 1.0.2 in the Linux wheel packages (#518).

• Fixed build with libpq versions < 9.3 (#520).

What's new in psycopg 2.7

New features:

• Added ~psycopg2.sql module to generate SQL dynamically (#308).

• Added replication-support (#322). Main authors are Oleksandr Shulgin and Craig Ringer, who deserve a huge thank you.

• Added ~psycopg2.extensions.parse_dsn() and ~psycopg2.extensions.make_dsn() functions (#321, #363). ~psycopg2.connect() now can take both dsn and keyword arguments, merging them together.

• Added ~psycopg2.__libpq_version__ and ~psycopg2.extensions.libpq_version() to inspect the version of the libpq library the module was bundled with (#35, #323).

• The attributes ~connection.notices and ~connection.notifies can be customized replacing them with any object exposing an !append() method (#326).

• Adapt network types to ipaddress objects when available. When not enabled, convert arrays of network types to lists by default. The old !Inet adapter is deprecated (#317, #343, #387).

• Added ~psycopg2.extensions.quote_ident() function (#359).

• Added ~connection.get_dsn_parameters() connection method (#364).

• ~cursor.callproc() now accepts a dictionary of parameters (#381).

• Give precedence to !__conform__() over superclasses to choose an object adapter (#456).

• Using Python C API decoding functions and codecs caching for faster unicode encoding/decoding (#473).

• ~cursor.executemany() slowness addressed by ~psycopg2.extras.execute_batch() and ~psycopg2.extras.execute_values() (#491).

• Added async_ as an alias for async to support Python 3.7 where async will become a keyword (#495).

• Unless in autocommit, do not use default_transaction_* settings to control the session characteristics as it may create problems with external connection pools such as pgbouncer; use BEGIN options instead (#503).

• ~connection.isolation_level is now writable and entirely separated from ~connection.autocommit; added ~connection.readonly, ~connection.deferrable writable attributes.

Bug fixes:

• Throw an exception trying to pass NULL chars as parameters (#420).

• Fixed error caused by missing decoding ~psycopg2.extras.LoggingConnection (#483).

• Fixed integer overflow in interval seconds (#512).

• Make ~psycopg2.extras.Range objects picklable (#462).

• Fixed version parsing and building with PostgreSQL 10 (#489).

Other changes:

• Dropped support for Python 2.5 and 3.1.

• Dropped support for client library older than PostgreSQL 9.1 (but older server versions are still supported).

• ~connection.isolation_level doesn't read from the database but will return ~psycopg2.extensions.ISOLATION_LEVEL_DEFAULT if no value was set on the connection.

• Empty arrays no more converted into lists if they don't have a type attached (#506)

• Fixed inconsistent state in externally closed connections (:tickets:#263, #311, #443).
• Report the server response status on errors (such as :ticket:#281).
• Raise !NotSupportedError on unhandled server response status (:ticket:#352).
• Allow overriding string adapter encoding with no connection (:ticket:#331).
• The ~psycopg2.extras.wait_select callback allows interrupting a long-running query in an interactive shell using :kbd:Ctrl-C (:ticket:#333).
• Fixed !PersistentConnectionPool on Python 3 (:ticket:#348).
• Fixed segfault on repr() of an unitialized connection (:ticket:#361).
• Allow adapting bytes using ~psycopg2.extensions.QuotedString on Python 3 (:ticket:#365).
• Added support for setuptools/wheel (:ticket:#370).
• Fix build on Windows with Python 3.5, VS 2015 (:ticket:#380).
• Fixed !errorcodes.lookup initialization thread-safety (:ticket:#382).
• Fixed !read() exception propagation in copy_from (:ticket:#412).
• Fixed possible NULL TZ decref (:ticket:#424).
• ~psycopg2.errorcodes map updated to PostgreSQL 9.5.

• Lists consisting of only None are escaped correctly (:ticket:#285).
• Fixed deadlock in multithread programs using OpenSSL (:ticket:#290).
• Correctly unlock the connection after error in flush (:ticket:#294).
• Fixed !MinTimeLoggingCursor.callproc() (:ticket:#309).
• Added support for MSVC 2015 compiler (:ticket:#350).

What's new in psycopg 2.6

New features:

• Added support for large objects larger than 2GB. Many thanks to Blake Rouse and the MAAS Team for the feature development.
• Python time objects with a tzinfo specified and PostgreSQL :sql:timetz data are converted into each other (:ticket:#272).

Bug fixes:

• Json adapter's !str() returns the adapted content instead of the !repr() (:ticket:#191).

• Named cursors used as context manager don't swallow the exception on exit (:ticket:#262).
• cursor.description can be pickled (:ticket:#265).
• Propagate read error messages in COPY FROM (:ticket:#270).
• PostgreSQL time 24:00 is converted to Python 00:00 (:ticket:#278).

• Added :sql:jsonb support for PostgreSQL 9.4 (:ticket:#226).
• Fixed segfault if COPY statements are passed to ~cursor.execute() instead of using the proper methods (:ticket:#219).
• Force conversion of pool arguments to integer to avoid potentially unbounded pools (:ticket:#220).
• Cursors :sql:WITH HOLD don't begin a new transaction upon move/fetch/close (:ticket:#228).
• Cursors :sql:WITH HOLD can be used in autocommit (:ticket:#229).
• ~cursor.callproc() doesn't silently ignore an argument without a length.
• Fixed memory leak with large objects (:ticket:#256).
• Make sure the internal _psycopg.so module can be imported stand-alone (to allow modules juggling such as the one described in :ticket:#201).

• Work around pip issue #1630 <https://github.com/pypa/pip/issues/1630>__ making installation via pip -e git+url impossible (:ticket:#18).
• Copy operations correctly set the cursor.rowcount attribute (:ticket:#180).
• It is now possible to call get_transaction_status() on closed connections.
• Fixed unsafe access to object names causing assertion failures in Python 3 debug builds (:ticket:#188).
• Mark the connection closed if found broken on poll() (from :ticket:#192 discussion)
• Fixed handling of dsn and closed attributes in connection subclasses failing to connect (from :ticket:#192 discussion).
• Added arbitrary but stable order to Range objects, thanks to Chris Withers (:ticket:#193).
• Avoid blocking async connections on connect (:ticket:#194). Thanks to Adam Petrovich for the bug report and diagnosis.
• Don't segfault using poorly defined cursor subclasses which forgot to call the superclass init (:ticket:#195).
• Mark the connection closed when a Socket connection is broken, as it happens for TCP connections instead (:ticket:#196).
• Fixed overflow opening a lobject with an oid not fitting in a signed int (:ticket:#203).
• Fixed handling of explicit default cursor_factory=None in connection.cursor() (:ticket:#210).
• Fixed possible segfault in named cursors creation.
• Fixed debug build on Windows, thanks to James Emerton.

• Fixed segfault pickling the exception raised on connection error (:ticket:#170).
• Meaningful connection errors report a meaningful message, thanks to Alexey Borzenkov (:ticket:#173).
• Manually creating lobject with the wrong parameter doesn't segfault (:ticket:#187).

• Fixed build on Solaris 10 and 11 where the round() function is already declared (#146).

• Fixed comparison of Range with non-range objects (#164). Thanks to Chris Withers for the patch.

• Fixed double-free on connection dealloc (#166). Thanks to Gangadharan S.A. for the report and fix suggestion.

What's new in psycopg 2.5

New features:

• Added JSON adaptation.

• Added support for PostgreSQL 9.2 range types.

• connection and cursor objects can be used in with statements as context managers as specified by recent |DBAPI|_ extension.

• Added ~psycopg2.extensions.Diagnostics object to get extended info from a database error. Many thanks to Matthew Woodcraft for the implementation (#149).

• Added connection.cursor_factory attribute to customize the default object returned by ~connection.cursor().

• Added support for backward scrollable cursors. Thanks to Jon Nelson for the initial patch (#108).

• Added a simple way to customize casting of composite types into Python objects other than namedtuples. Many thanks to Ronan Dunklau and Tobias Oberstein for the feature development.

• connection.reset() implemented using DISCARD ALL on server versions supporting it.

Bug fixes:

• Properly cleanup memory of broken connections (#148).

• Fixed bad interaction of setup.py with other dependencies in Distribute projects on Python 3 (#153).

Other changes:

• Added support for Python 3.3.

• Dropped support for Python 2.4. Please use Psycopg 2.4.x if you need it.

• ~psycopg2.errorcodes map updated to PostgreSQL 9.2.

• Dropped Zope adapter from source repository. ZPsycopgDA now has its own project at <https://github.com/psycopg/ZPsycopgDA>.

• Fixed 'cursor()' arguments propagation in connection subclasses and overriding of the 'cursor_factory' argument. Thanks to Corry Haines for the report and the initial patch (:ticket:#105).
• Dropped GIL release during string adaptation around a function call invoking a Python API function, which could cause interpreter crash. Thanks to Manu Cupcic for the report (:ticket:#110).
• Close a green connection if there is an error in the callback. Maybe a harsh solution but it leaves the program responsive (:ticket:#113).
• 'register_hstore()', 'register_composite()', 'tpc_recover()' work with RealDictConnection and Cursor (:ticket:#114).
• Fixed broken pool for Zope and connections re-init across ZSQL methods in the same request (:tickets:#123, #125, #142).
• connect() raises an exception instead of swallowing keyword arguments when a connection string is specified as well (:ticket:#131).
• Discard any result produced by 'executemany()' (:ticket:#133).
• Fixed pickling of FixedOffsetTimezone objects (:ticket:#135).
• Release the GIL around PQgetResult calls after COPY (:ticket:#140).
• Fixed empty strings handling in composite caster (:ticket:#141).
• Fixed pickling of DictRow and RealDictRow objects.

• The close() methods on connections and cursors don't raise exceptions if called on already closed objects.
• Fixed fetchmany() with no argument in cursor subclasses (:ticket:#84).
• Use lo_creat() instead of lo_create() when possible for better interaction with pgpool-II (:ticket:#88).
• Error and its subclasses are picklable, useful for multiprocessing interaction (:ticket:#90).
• Better efficiency and formatting of timezone offset objects thanks to Menno Smits (:tickets:#94, #95).
• Fixed 'rownumber' during iteration on cursor subclasses. Regression introduced in 2.4.4 (:ticket:#100).
• Added support for 'inet' arrays.
• Fixed 'commit()' concurrency problem (:ticket:#103).
• Codebase cleaned up using the GCC Python plugin's static analysis tool, which has revealed several unchecked return values, possible NULL dereferences, reference counting problems. Many thanks to David Malcolm for the useful tool and the assistance provided using it.

• 'register_composite()' also works with the types implicitly defined after a table row, not only with the ones created by 'CREATE TYPE'.
• Values for the isolation level symbolic constants restored to what they were before release 2.4.2 to avoid breaking apps using the values instead of the constants.
• Named DictCursor/RealDictCursor honour itersize (:ticket:#80).
• Fixed rollback on error on Zope (:ticket:#73).
• Raise 'DatabaseError' instead of 'Error' with empty libpq errors, consistently with other disconnection-related errors: regression introduced in release 2.4.1 (:ticket:#82).

• connect() supports all the keyword arguments supported by the database
• Added 'new_array_type()' function for easy creation of array typecasters.
• Added support for arrays of hstores and composite types (:ticket:#66).
• Fixed segfault in case of transaction started with connection lost (and possibly other events).
• Fixed adaptation of Decimal type in sub-interpreters, such as in certain mod_wsgi configurations (:ticket:#52).
• Rollback connections in transaction or in error before putting them back into a pool. Also discard broken connections (:ticket:#62).
• Lazy import of the slow uuid module, thanks to Marko Kreen.
• Fixed NamedTupleCursor.executemany() (:ticket:#65).
• Fixed --static-libpq setup option (:ticket:#64).
• Fixed interaction between RealDictCursor and named cursors (:ticket:#67).
• Dropped limit on the columns length in COPY operations (:ticket:#68).
• Fixed reference leak with arguments referenced more than once in queries (:ticket:#81).
• Fixed typecasting of arrays containing consecutive backslashes.
• 'errorcodes' map updated to PostgreSQL 9.1.

• Added 'set_session()' method and 'autocommit' property to the connection. Added support for read-only sessions and, for PostgreSQL 9.1, for the "repeatable read" isolation level and the "deferrable" transaction property.
• Psycopg doesn't execute queries at connection time to find the default isolation level.
• Fixed bug with multithread code potentially causing loss of sync with the server communication or lock of the client (:ticket:#55).
• Don't fail import if mx.DateTime module can't be found, even if its support was built (:ticket:#53).
• Fixed escape for negative numbers prefixed by minus operator (:ticket:#57).
• Fixed refcount issue during copy. Reported and fixed by Dave Malcolm (:ticket:#58, Red Hat Bug 711095).
• Trying to execute concurrent operations on the same connection through concurrent green thread results in an error instead of a deadlock.
• Fixed detection of pg_config on Window. Report and fix, plus some long needed setup.py cleanup by Steve Lacy: thanks!

• Use own parser for bytea output, not requiring anymore the libpq 9.0 to parse the hex format.
• Don't fail connection if the client encoding is a non-normalized variant. Issue reported by Peter Eisentraut.
• Correctly detect an empty query sent to the backend (:ticket:#46).
• Fixed a SystemError clobbering libpq errors raised without SQLSTATE. Bug vivisectioned by Eric Snow.
• Fixed interaction between NamedTuple and server-side cursors.
• Allow to specify --static-libpq on setup.py command line instead of just in 'setup.cfg'. Patch provided by Matthew Ryan (:ticket:#48).

What's new in psycopg 2.4

New features and changes:

• Added support for Python 3.1 and 3.2. The conversion has also brought several improvements:

  • Added 'b' and 't' mode to large objects: write can deal with both bytes strings and unicode; read can return either bytes strings or decoded unicode.
  • COPY sends Unicode data to files implementing 'io.TextIOBase'.
  • Improved PostgreSQL-Python encodings mapping.
  • Added a few missing encodings: EUC_CN, EUC_JIS_2004, ISO885910, ISO885916, LATIN10, SHIFT_JIS_2004.
  • Dropped repeated dictionary lookups with unicode query/parameters.

• Improvements to the named cursors:

  • More efficient iteration on named cursors, fetching 'itersize' records at time from the backend.
  • The named cursors name can be an invalid identifier.

• Improvements in data handling:

  • Added 'register_composite()' function to cast PostgreSQL composite types into Python tuples/namedtuples.
  • Adapt types 'bytearray' (from Python 2.6), 'memoryview' (from Python 2.7) and other objects implementing the "Revised Buffer Protocol" to 'bytea' data type.
  • The 'hstore' adapter can work even when the data type is not installed in the 'public' namespace.
  • Raise a clean exception instead of returning bad data when receiving bytea in 'hex' format and the client libpq can't parse them.
  • Empty lists correctly roundtrip Python -> PostgreSQL -> Python.

• Other changes:

  • 'cursor.description' is provided as named tuples if available.
  • The build script refuses to guess values if 'pg_config' is not found.
  • Connections and cursors are weakly referenceable.

Bug fixes:

• Fixed adaptation of None in composite types (:ticket:#26). Bug report by Karsten Hilbert.
• Fixed several reference leaks in less common code paths.
• Fixed segfault when a large object is closed and its connection no more available.
• Added missing icon to ZPsycopgDA package, not available in Zope 2.12.9 (:ticket:#30). Bug report and patch by Pumukel.
• Fixed conversion of negative infinity (:ticket:#40). Bug report and patch by Marti Raudsepp.

• Fixed segfault with middleware not passing DateStyle to the client (:ticket:#24). Bug report and patch by Marti Raudsepp.

• Fixed build problem on CentOS 5.5 x86_64 (:ticket:#23).

What's new in psycopg 2.3

psycopg 2.3 aims to expose some new features introduced in PostgreSQL 9.0.

Main new features:

• dict to hstore adapter and hstore to dict typecaster, using both 9.0 and pre-9.0 syntax.
• Two-phase commit protocol support as per DBAPI specification.
• Support for payload in notifications received from the backend.
• namedtuple-returning cursor.
• Query execution cancel.

Other features and changes:

• Dropped support for protocol 2: Psycopg 2.3 can only connect to PostgreSQL servers with version at least 7.4.
• Don't issue a query at every connection to detect the client encoding and to set the datestyle to ISO if it is already compatible with what expected.
• mogrify() now supports unicode queries.
• Subclasses of a type that can be adapted are adapted as the superclass.
• errorcodes knows a couple of new codes introduced in PostgreSQL 9.0.
• Dropped deprecated Psycopg "own quoting".
• Never issue a ROLLBACK on close/GC. This behaviour was introduced as a bug in release 2.2, but trying to send a command while being destroyed has been considered not safe.

Bug fixes:

• Fixed use of PQfreemem instead of free in binary typecaster.
• Fixed access to freed memory in conn_get_isolation_level().
• Fixed crash during Decimal adaptation with a few 2.5.x Python versions (:ticket:#7).
• Fixed notices order (:ticket:#9).

Bux fixes:

• the call to logging.basicConfig() in pool.py has been dropped: it was messing with some projects using logging (and a library should not initialize the logging system anyway.)
• psycopg now correctly handles time zones with seconds in the UTC offset. The old register_tstz_w_secs() function is deprecated and will raise a warning if called.
• Exceptions raised by the column iterator are propagated.
• Exceptions raised by executemany() iterators are propagated.

Bux fixes:

• psycopg now builds again on MS Windows.

What's new in psycopg 2.2

This is the first release of the new 2.2 series, supporting not just one but two different ways of executing asynchronous queries, thanks to Jan and Daniele (with a little help from me and others, but they did 99% of the work so they deserve their names here in the news.)

psycopg now supports both classic select() loops and "green" coroutine libraries. It is all in the documentation, so just point your browser to doc/html/advanced.html.

Other new features:

• truncate() method for lobjects.
• COPY functions are now a little bit faster.
• All builtin PostgreSQL to Python typecasters are now available from the psycopg2.extensions module.
• Notifications from the backend are now available right after the execute() call (before client code needed to call isbusy() to ensure NOTIFY reception.)
• Better timezone support.
• Lots of documentation updates.

Bug fixes:

• Fixed some gc/refcounting problems.
• Fixed reference leak in NOTIFY reception.
• Fixed problem with PostgreSQL not casting string literals to the correct types in some situations: psycopg now add an explicit cast to dates, times and bytea representations.
• Fixed TimestampFromTicks() and TimeFromTicks() for seconds >= 59.5.
• Fixed spurious exception raised when calling C typecasters from Python ones.

New features:

• Support for adapting tuples to PostgreSQL arrays is now enabled by default and does not require importing psycopg2.extensions anymore.
• "can't adapt" error message now includes full type information.
• Thank to Daniele Varrazzo (piro) psycopg2's source package now includes full documentation in HTML and plain text format.

Bug fixes:

• No loss of precision when using floats anymore.
• decimal.Decimal "nan" and "infinity" correctly converted to PostgreSQL numeric NaN values (note that PostgreSQL numeric type does not support infinity but just NaNs.)
• psycopg2.extensions now includes Binary.

It seems we're good citizens of the free software ecosystem and that big big big companies and people ranting on the pgsql-hackers mailing list we'll now not dislike us. g (See LICENSE file for the details.)

New features:

• Support for UUID arrays.
• It is now possible to build psycopg linking to a static libpq library.

Bug fixes:

• Fixed a deadlock related to using the same connection with multiple cursors from different threads.
• Builds again with MSVC.

New features:

• The connection object now has a reset() method that can be used to reset the connection to its default state.

Bug fixes:

• copy_to() and copy_from() now accept a much larger number of columns.
• Fixed PostgreSQL version detection.
• Fixed ZPsycopgDA version check.
• Fixed regression in ZPsycopgDA that made it behave wrongly when receiving serialization errors: now the query is re-issued as it should be by propagating the correct exception to Zope.
• Writing "large" large objects should now work.

New features:

• DictRow and RealDictRow now use less memory. If you inherit on them remember to set slots for your new attributes or be prepare to go back to old memory usage.

Bug fixes:

• Fixed exception in setup.py.
• More robust detection of PostgreSQL development versions.
• Fixed exception in RealDictCursor, introduced in 2.0.10.

New features:

• A specialized type-caster that can parse time zones with seconds is now available. Note that after enabling it (see extras.py) "wrong" time zones will be parsed without raising an exception but the result will be rounded.
• DictCursor can be used as a named cursor.
• DictRow now implements more dict methods.
• The connection object now expose PostgreSQL server version as the .server_version attribute and the protocol version used as .protocol_version.
• The connection object has a .get_parameter_status() methods that can be used to obtain useful information from the server.

Bug fixes:

• None is now correctly always adapted to NULL.
• Two double memory free errors provoked by multithreading and garbage collection are now fixed.
• Fixed usage of internal Python code in the notice processor; this should fix segfaults when receiving a lot of notices in multithreaded programs.
• Should build again on MSVC and Solaris.
• Should build with development versions of PostgreSQL (ones with -devel version string.)
• Fixed some tests that failed even when psycopg was right.

New features:

• The connection object now has a get_backend_pid() method that returns the current PostgreSQL connection backend process PID.
• The PostgreSQL large object API has been exposed through the Cursor.lobject() method.

Bug fixes:

• Some fixes to ZPsycopgDA have been merged from the Debian package.
• A memory leak was fixed in Cursor.executemany().
• A double free was fixed in pq_complete_error(), that caused crashes under some error conditions.