RELEASE: psycopg 2.2.0

With many thanks to all the contributors here it is, psycopg 2.2.0:

http://initd.org/pub/software/psycopg/psycopg2-2.2.0.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.2.0.tar.gz.asc
http://initd.org/pub/software/psycopg/ChangeLog-2.2

From this release on I'll also provide "stable" URLs to the last
available version; so you can download psycopg 2.0 or 2.2 from:

http://initd.org/pub/software/psycopg/psycopg2-2.0-latest.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0-latest.tar.gz.asc
http://initd.org/pub/software/psycopg/psycopg2-2.2-latest.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.2-latest.tar.gz.asc

As always, an excerpt from the NEWS file follows.

Have fun,
federico

What's new in psycopg 2.2.0
---------------------------

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.

RELEASE: psycopg2 2.0.14

Hi *,

here it is, psycopg2 2.0.14 released under the LGPL3 (see LICENSE file
for details):

http://initd.org/pub/software/psycopg/psycopg2-2.0.14.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.14.tar.gz.asc
http://initd.org/pub/software/psycopg/ChangeLog-2.0

As always, an excerpt from the NEWS file follows.

Have fun,
federico

What's new in psycopg 2.0.14
----------------------------

* 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.

RELEASE: psycopg 2.0.12

Hi *,

I just fixed a couple of bugs in psycopg so here's the new release. I
still have a couple of patches to review and some python 3 work that
I'll release later this August as psycopg 2.1 (with Python 3 support).

In the meantime here is a better (hopefully) psycopg for Python 2:

http://initd.org/pub/software/psycopg/psycopg2-2.0.12.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.12.tar.gz.asc
http://initd.org/pub/software/psycopg/ChangeLog-2.0

An excerpt from the NEWS file follows. Have fun,

federico

What's new in psycopg 2.0.12
---------------------------

* 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

RELEASE: psycopg 2.0.10

Hi *,

as promised here is the release that plugs some of the segfaults that
popped up lately. It contains both Gangadharan fixes on
connection/cursor dealloc and my rework of the notice callback (that
caused some segfaults in case of notices processed while
multithreading.)

The signed release is available at the usual place:

http://initd.org/pub/software/psycopg/psycopg2-2.0.10.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.10.tar.gz.asc

And here is the excerpt from the NEWS file:

What's new in psycopg 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.

RELEASE: Psycopg 2.0.9

Hi *,

another year, another release, eheh. I hope to have the Python 2.6/3.0
release ready pretty soon but please, don't forget to ping me. I am
laaazy nowdays. Signed downloads from:

http://initd.org/pub/software/psycopg/psycopg2-2.0.9.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.9.tar.gz.asc

And ChangeLog:

http://initd.org/pub/software/psycopg/ChangeLog-2.0

An excerpt of the NEWS file follows. As always,

have fun,
federico

What's new in psycopg 2.0.9
---------------------------

* New features:
  - COPY TO/COPY FROM queries now can be of any size and psycopg will
    correctly quote separators.
  - float values Inf and NaN are now correctly handled and can
    round-trip to the database.
  - executemany() now return the numer of total INSERTed or UPDATEd
    rows. Note that, as it has always been, executemany() should not
    be used to execute multiple SELECT statements and while it will
    execute the statements without any problem, it will return the

RELEASE: psycopg 2.0.8

Hi everybody,

this is a little bit late but here we are: release 2.0.8. It includes
some fixes but not the latest patches sent to the mailing list. Download
the (signed) tarball from:

http://initd.org/pub/software/psycopg/psycopg2-2.0.8.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.8.tar.gz.sig

An excerpt from the NEWS file follows.

Have fun,
federico

What's new in psycopg 2.0.8
---------------------------

* 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.

--

-- 

RELEASE: psycopg 2.0.6 (the PyConUno release)

Hi *,

tomorrow I'll be at PyConUno, the first italian conference about Python,
giving a talk about psycopg. What better than release 2.0.6 final before
leaving for Firenze for the week-end? So here it is, tarball, signature
and ChangeLog:

http://initd.org/pub/software/psycopg/psycopg2-2.0.6.tar.gz
http://initd.org/pub/software/psycopg/psycopg2-2.0.6.tar.gz.asc
http://initd.org/pub/software/psycopg/ChangeLog

A lot of changes went into 2.0.6 (see the ChangeLog for the details).
Here is a little excerpt from NEWS file, as always.

What's new in psycopg 2.0.6
---------------------------

* 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.

RELEASE: psycopg 2.0.6 beta 2

Hi *,

sorry for being so late but during the last few months I was swamped in
work. Fortunately enough we're approaching te mythical one-dot-oh date
and psycopg release cycle will probably benefit from a little more free
hacking time. Let's start with the final beta for 2.0.6, to be shortly
followed by 2.0.6 final:

http://initd.org/pub/software/psycopg/psycopg2-2.0.6b2.tar.gz

that fixes all reproducible bugs tagged for the 2.0.6 milestone and
quite some other fixes (especially from David Rushby that made psycopg
much more stable when used with Python 2.5 and on 64 bit architectures.)
An excerpt from the NEWS file follows. As always..

have fun,
federico

What's new in psycopg 2.0.6
---------------------------

* Full support for PostgreSQL 8.2, including NULLs in arrays.

* Full support for Python 2.5 and 64 bit architectures.

* Support for almost all PostgreSQL encodings.

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

* Support for per-connection type-casters (used by ZPsycopgDA too, this

RELEASE: psycopg 2.0.6 beta 1

Hi *,

after quite some work I am almost ready to release psycopg 2.0.6 but
while I work to fix some remaining issues, please test this first beta
and report any regression to me or to the list. This version should fix
almost all important bugs that were posted during the last two months
for which I had enough information. It also adds support for NULL values
in arrays, introduced in PostreSQL 8.2. An excerpt from the NEWS file
follows; downloads from:

http://initd.org/pub/software/psycopg/psycopg2-2.0.6b1.tar.gz

What's new in psycopg 2.0.6
---------------------------

* Full support for PostgreSQL 8.2, including NULLs in arrays.

* Support for almost all PostgreSQL encodings.

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

* We now have a full list of PostgreSQL error codes available by
  importing the psycopg2.errorcodes module.

* 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

RELEASE: psycopg 2.0.5.1

Just a dot release to fix the build problems on MSCV and older gcc
versions. If you're experiencing build problems try this one, else just
stay with 2.0.5 (they are identical apart from small change to make
compilers happy). Download from:

http://initd.org/pub/software/psycopg/psycopg2-2.0.5.1.tar.gz

Have fun,
federico

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...
INIT.D Developer                                           fog@...
  The devil speaks truth much oftener than he's deemed.
   He has an ignorant audience.    -- Byron (suggested by Alice Fontana)

_______________________________________________
Psycopg-announce mailing list
Psycopg-announce@...
http://lists.initd.org/mailman/listinfo/psycopg-announce

RELEASE: psycopg 2.0.5

Mm.. fixing all the open tickets and packaging this release was so fast
that I surely missed something so be prepared for a 2.0.6 next week. :)

Jokes apart psycopg 2.0.5 is available from the usual place with its
ChangeLog:

http://initd.org/pub/software/psycopg/psycopg2-2.0.5.tar.gz
http://initd.org/pub/software/psycopg/ChangeLog-2.0

A brief excerpt from the NEWS file follows.

As always, have fun,
federico

What's new in psycopg 2.0.5
­--------------------------

* 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

--

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                fog@...