Add support for two-phase commit DBAPI extension. Thanks to Mariano Reingart’s TPC code on the Google Code version:
https://code.google.com/p/pg8000/source/detail?r=c8609701b348b1812c418e2c7
on which the code for this commit is based.
Deprecate copy_from() and copy_to() The methods copy_from() and copy_to() of the Cursor object are deprecated because it’s simpler and more flexible to use the execute() method with a fileobj parameter.
Fixed bug in reporting unsupported authentication codes. Thanks to https://github.com/hackgnar for reporting this and providing the fix.
Have a default for the user paramater of the connect() function. If the user parameter of the connect() function isn’t provided, look first for the PGUSER then the USER environment variables. Thanks to Alex Gaynor https://github.com/alex for this suggestion.
Before PostgreSQL 8.2, COPY didn’t give row count. Until PostgreSQL 8.2 (which includes Amazon Redshift which forked at 8.0) the COPY command didn’t return a row count, but pg8000 thought it did. That’s fixed now.
Fixed bug where there were missing trailing zeros after the decimal point in the NUMERIC type. For example, the NUMERIC value 1.0 was returned as 1 (with no zero after the decimal point).
This is fixed this by making pg8000 use the text rather than binary representation for the numeric type. This actually doubles the speed of numeric queries.
For Python 3, the bytes type replaces the pg8000.Bytea type. For backward compatibility the pg8000.Bytea still works under Python 3, but its use is deprecated.
A single codebase for Python 2 and 3.
Everything (functions, properties, classes) is now available under the pg8000 namespace. So for example:
The old locations are deprecated, but still work for backward compatibility.
Lots of performance improvements.
Add facility for turning auto-commit on. This follows the suggestion of funkybob to fix the problem of not be able to execute a command such as ‘create database’ that must be executed outside a transaction. Now you can do conn.autocommit = True and then execute ‘create database’.
Add support for the PostgreSQL uid type. Thanks to Rad Cirskis.
Add support for the PostgreSQL XML type.
Add support for the PostgreSQL enum user defined types.
Fix a socket leak, where a problem opening a connection could leave a socket open.
Fix empty array issue. https://github.com/mfenniak/pg8000/issues/10
Fix scale on numeric types. https://github.com/mfenniak/pg8000/pull/13
Fix numeric_send. Thanks to Christian Hofstaedtler.