We have just released two Psycopg versions: 2.5.5 containing a few bug fixes and 2.6 introducing some new features.
Psycopg 2.5.4 has been released. You can get it from:
This version supports the new jsonb PostgreSQL type out-of-the-box. And of course there are a few bug fixed:
Posted by Daniele Varrazzo on 2014-07-20
Tagged as recipe
Cancelling a long running query from Python is not something that happens automatically: the libpq doesn't react to Python signals so the only way to stop a query is to run a pg_cancel_backend from another process. Killing the Python process won't cancel the query: it will run until completion and then rolled back. This makes working wth long-running query from the Python interpreter somewhat frustrating.
Psycopg 2.5.3 has been released. You can get it from:
This version contains several bug fixes over the previous release 2.5.2:
Psycopg 2.5.2 has been released. You can get it from:
This version contains a few bug fixes over the previous release 2.5.1:
- 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).
Thank you very much to all the people who helped during the development!
Psycopg 2.5.1 has been released. You can get it from:
The version contains a few bug fixes over the previous 2.5:
- Fixed build on Solaris 10 and 11 where the round() function is already declared (ticket #146).
- Fixed comparison of Range with non-range objects (ticket #164). Thanks to Chris Withers for the patch.
- Fixed double-free on connection dealloc (ticket #166). Thanks to Gangadharan S.A. for the report and fix suggestion.
We are happy to introduce the release 2.5 of Psycopg, packed with several juicy new features!
Here are a few highlights of the release:
I'm happy to announce the release of Psycopg 2.4.6: a huge thank you to the many contributors.
This is a bugfix release, introducing no new feature. There are several small corrections in different areas (copy, adaptation, use of extra cursors, stability). The biggest improvements are with the Zope adapter: Zope users using previous 2.4.x versions are encouraged to update to version 2.4.6 soon.
Posted by Daniele Varrazzo on 2012-10-01
Tagged as recipe
Although the libpq library supports prepared statements, psycopg2 doesn't offer yet a direct way to access the relevant functions. This will probably change in the future, but in the meantime it is possible to use prepared statements in PostgreSQL using the PREPARE SQL command.
Many thanks to everybody that contributed with bug reports and comments to this release!