Psycopg2

^^^^^^^^^^^^^^^^^^^^^^^^^^^

Better support for PostgreSQL, Python and win32:

- full support for PostgreSQL 8.2, including NULLs in arrays
- support for almost all existing PostgreSQL encodings
- full list of PostgreSQL error codes available by importing the
psycopg2.errorcodes module
- full support for Python 2.5 and 64 bit architectures
- better build support on win32 platform

Support for per-connection type-casters (used by ZPsycopgDA too, this
fixes a long standing bug that made different connections use a random
set of date/time type-casters instead of the configured one.)

Better management of times and dates both from Python and in Zope.

copy_to and copy_from now take an extra "columns" parameter.

Python tuples are now adapted to SQL sequences that can be used with
the "IN" operator by default if the psycopg2.extensions module is
imported (i.e., the SQL_IN adapter was moved from extras to extensions.)

Fixed some small buglets and build glitches:

- removed double mutex destroy
- removed all non-constant initializers
- fixed PyObject_HEAD declarations to avoid memory corruption
on 64 bit architectures
- fixed several Python API calls to work on 64 bit architectures
- applied compatibility macros from PEP 353
- now using more than one argument format raise an error instead of
a segfault

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

* Now it really, really builds on MSVC and older gcc versions.

^^^^^^^^^^^^^^^^^^^^^^^^^^^

* Fixed various buglets such as:

- segfault when passing an empty string to Binary()
- segfault on null queries
- segfault and bad keyword naming in .executemany()
- OperationalError in connection objects was always None

* Various changes to ZPsycopgDA to make it more zope2.9-ish.

* connect() now accept both integers and strings as port parameter

^^^^^^^^^^^^^^^^^^^^^^^^^^^

* Fixed float conversion bug introduced in 2.0.3.

^^^^^^^^^^^^^^^^^^^^^^^^^^^

* Fixed various buglets and a memory leak (see ChangeLog for details)

^^^^^^^^^^^^^^^^^^^^^^^^^^^

* Fixed a bug in array typecasting that sometimes made psycopg forget about
the last element in the array.

* Fixed some minor buglets in string memory allocations.

* Builds again with compilers different from gcc (warning about PostgreSQL
version is issued only if __GCC__ is defined.)