Psycopg 2.4.5 released

Posted by Daniele Varrazzo on March 29, 2012
Tagged as news, release

Many thanks to everybody that contributed with bug reports and comments to this release!

What's new in psycopg 2.4.5

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

Comments (14 posted).

Comment #1
Sept. 20, 2012, 1:55 p.m.

Is it possible to use copy-to in asynrochnous mode?

Comment #2
Daniele Varrazzo
Sept. 20, 2012, 3:35 p.m.

Unfortunately no, copy is not supported yet in async mode.

Comment #3
Sept. 24, 2012, 4:21 p.m.

Will it be possible in next versions ???

Comment #4
Daniele Varrazzo
Sept. 24, 2012, 4:32 p.m.

It's not one of the things planned for 2.4.6: we have several bug reports and PG 9.2 datatypes support already in the make.

If there is financial support for the feature I can work at its development, otherwise it will have to wait after the next release, or until somebody provides patches for it.

Comment #5
Sept. 26, 2012, 12:09 p.m.

Please where can I find the function that calls error message when calling async copy_to. thanks

Comment #6
Daniele Varrazzo
Sept. 26, 2012, 1:56 p.m.

It's in psycopg/cursor_type.c, the macros EXC_IF_CURS_ASYNC and EXC_IF_GREEN in psyco_curs_copy_to().

If you want to develop the feature you can have much better feedback if you sign up to the mailing list. Thank you very much.

Comment #7
Nov. 8, 2012, 12:33 a.m.

Where might one find a Win amd64 python 3.3 build of psycopg?

Comment #8
Daniele Varrazzo
Nov. 8, 2012, 12:55 a.m.

Python 3.3 is not supported yet: there is no major stopper and you could compile it yourself, but until we get a response on this issue there won't be official support.

Comment #9
Dec. 7, 2012, 12:40 p.m.

Hi. Is the version 2.4.5 compatible with Postgresql 8.3? Thanks

Comment #10
Daniele Varrazzo
Dec. 7, 2012, 1:12 p.m.

Yes it is. It is tested down to PostgreSQL 7.4.

Comment #11
Dec. 15, 2012, 10:33 p.m.

When python 3.3 will be official supported by psycopg2 ?

Comment #12
Daniele Varrazzo
Dec. 16, 2012, 12:11 a.m.

Support for 3.3 is already implemented, but there is something I'm not sure and got no reply yet to my question, see <>. If we get a reply soon we can include it in release 2.5.

Comment #13
April 2, 2013, 1:10 a.m.


Just want to know, when release 2.5 will be available.


Comment #14
Daniele Varrazzo
April 2, 2013, 2:26 a.m.

I think it will be released this week. I've just made my mind about the last bug found on the zope adapter and it may be left as it is for now.

Feel free to add a new comment. You can use reST syntax.