Latest articles
Cancelling PostgreSQL statements from Python
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 with long-running query from the Python interpreter somewhat frustrating.
Psycopg 2.5.3 Released
Posted by Daniele Varrazzo on 2014-05-13
Tagged as
news,
release
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 released
Posted by Daniele Varrazzo on 2014-01-07
Tagged as
news,
release
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 released
Posted by Daniele Varrazzo on 2013-06-23
Tagged as
news,
release
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.
Happy hacking!
Psycopg 2.5 released
Posted by Daniele Varrazzo on 2013-04-07
Tagged as
news,
release
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:
Psycopg 2.4.6 released
Posted by Daniele Varrazzo on 2012-12-12
Tagged as
news,
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.
Prepared statements in Psycopg
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.
Psycopg 2.4.5 released
Posted by Daniele Varrazzo on 2012-03-29
Tagged as
news,
release
Many thanks to everybody that contributed with bug reports and comments to this release!
Psycopg 2.4.4 released
Posted by Daniele Varrazzo on 2011-12-19
Tagged as
news,
release
After a short discussion on this list we decided to change the definitions of isolation levels to make sure old code using numeric constants (both psycopg1 and psycopg2) continue to works. Other small fixes are included in the release: see below for details.
Psycopg 2.4.3 released
Posted by Daniele Varrazzo on 2011-12-12
Tagged as
news,
release
Mostly a bugfix release, with as usual a couple of small feature added: