Asyncpg

Backwards Incompatible Changes
------------------------------

asyncpg now reports the server version as x.0.y for PostgreSQL 10.0 and later.
This is in alignment with how upstream is interpreting the "minor" version
component now. (elprans in 1fa12fe2)

Improvements
------------

* Support timeouts in `Connection.close()` and `Pool.release()`
(by elprans in bdfdd898 for 220)

* Invalidate type cache on schema changes affecting statement result.
A new `Connection.reload_schema_state()` method.
(by vitaly-burovoy in b04556e9)

* Add CrateDB detection
(by mfussenegger in afc1038f)

Bug Fixes
---------

* Make prepared statement uid generator global
(by 1st1 in 3e43fcf5)

* Document pgbouncer-related prepared statement breakage
(by elprans in 4a3713f7 for 121)

* Fix unaligned access issues in host-network byte I/O on ARM
(by elprans in c04576db for 216)

* Fix issues with timetz type I/O
(by vitaly-burovoy in 7b6c0833)

* Consistently use postgres/postgres as database/user pair in tests
(by elprans in b4ce7403)

* Fix `Range.__hash__()`
(by eumiro in 46f468c9)

* Guard transaction methods against underlying connection release
(by elprans in 59e2878b for 232)

Backwards Incompatible Changes

* Drop support for PostgreSQL 9.1
(by elprans in eaf298b4)

* Remove the deprecated "binary" parameter from `Connection.set_type_codec()`
(by elprans in 9ad6625a)


New Features

* Add support for PostgreSQL 10
(by elprans)


Bug Fixes

* Document that single fetches can return None
(by khazhyk in 23394c9d)

* Fix type introspection being very slow on large databases
(by elprans in e0c44ced for 186)

* Fix copy tests on PostgreSQL < 9.4
(by elprans in 327058f8)

* Fix DeprecationWarning in tests
(by elprans in 3f9523c2)

* Fix intermittent authentication failures against PostgreSQL 10 servers
(by elprans in 498213e6 for 158)

* Do not attempt to connect to Unix sockets on Windows when host is not set
(by elprans in 8a32fc4b for 184)

* Guard against incorrect use of resources associated with a connection
(by elprans in 089ac818, 93bf26f3 for 190)

* Warn when there are active listeners on a connection that is released
(by elprans in d085d2cc for 190)

* Add a test for cursors on a standby replica.
(by elprans in c484a470 for 66)

* Clarify the argument/parameter count mismatch exception
(by elprans in b6fe0186 for 178)

* Fix `TypeError` on `get_attributes` when result has no columns
(by fantix in f29de232)

* protocol: Use `try`-`finally` explicitly every time we create a waiter
(by 1st1 in 50edd8c8)

* Call correct parent constructor in `InterfaceWarning.__init__`
(by elprans in eec98b0b)

* Allow grabbing the version information programmatically.
(by s0undt3ch in fa6dbc46)

* Use the general statement cache for type introspection
(by elprans in 57c9ffdc for 198)

* Fix issues with inet type I/O
(by elprans in e54f02e6 for 37)

* Handle inactive connection closes while stored in the pool
(by AmatanHead in 9744adee)

New Features

* Implement `as_dict()` method for `PostgresMessage`.
(by vitaly-burovoy in 90725f1f)

* Add API for receiving log messages `connection.add_log_listener()`.
(by vitaly-burovoy and 1st1 in 1b1893df and f072f883 for 144)

* Add support for "tuple" exchange format for codec overrides.
(by elprans in 0453243b and d27dda72)

* Implement binary format codec for numeric type.
(by elprans in a5413eb0 for 157)


Bug Fixes

* Fix boundary checks for integers.
(by vitaly-burovoy in e0829104 and dfcf1356)

* Fix handling of `NULL`s in copy_records_to_table().
(by elprans in 991b1ae8 for 153)

* Raise an error when a binary `COPY FROM` is attempted w/o appropriate codec.
(by elprans in 7aac14e2 for 157)

* Fix `Record.items()` to support duplicate keys. See 28 for details.
(by 1st1 in 39b390c3 for 28)

* Fix `Record.keys()` to correctly return duplicate keys. See 28.
(by 1st1 in b06114de for 28)

* Call notifications listeners using `loop.call_soon()`.
(by 1st1 in 83d08bd8)

* Make `PoolConnectionProxy` more dynamic. Fixes 155.
(by 1st1 in 6ca1f28b for 155)

* Make sure `set_type_codec()` overrides core codec for all formats.
(by elprans in 9c32b86f for 140)

* New severity "V" field as "severity_en" attribute.
(by vitaly-burovoy in 35bce5a8)

* Make interval decoding logic match that of psycopg2.
(by elprans in 6b484433 for 150)

Backwards Incompatible Changes

* Make `timeout` param of `executemany()` a keyword-only kwarg.
(by 1st1 in bb326fc0)

* Prohibit passing non-string instances as text arguments to queries.
(by elprans in ccc5f7a5)

* `connect()` and `create_pool()` no longer accept arbitrary
keyword arguments for server settings. Use new `server_settings`
argument for that.


New Features

* Add support for COPY IN.
(by elprans in 10d95d43 for 123)

* Add support for COPY OUT.
(by elprans and 1st1 in 5662d9f5 for 21)


Bug Fixes

* Refactor args parsing and config management for `connect()` and
`create_pool()`.
(by 1st1 in f280a566)

* support postgres-xl version
(by songjy in ffb89592)

* Fix erroneous codec cache invalidation on internal codec aliasing.
(by elprans in df64f554 for 133)

* Fix potential segfault in text array decoder.
(by elprans in bbd116be)

* Limit max number of arguments (closes 127).
(by 1st1 in 128910e4 for 127)


Documentation

* Expand usage documentation, add FAQ.
(by elprans in e4bef17f)

New features

* Add new Connection parameter: `max_cacheable_statement_size`.
(by 1st1 in b1f87ebe for 115)


Bug fixes

* Require `command_timeout` argument of `connect()` be greater than 0.
(by 1st1 in 7b7ce990)

* Fix SSL support in connection pool.
(by elprans in b89fb458 for 119)

* Make timeout in connect() consistent.
(by 1st1 in 1d8f5cf1 for 117)

New features

* Add support for SSL connections.
(by 1st1 in 5836a8fc for 25)

* Add `max_cached_statement_lifetime` parameter to `asyncpg.connect()`.
(by 1st1 in 10955fdd for 76)

* Add `max_inactive_connection_lifetime` parameter to `asyncpg.create_pool()`.
(by 1st1 in a2935aed)

* Expose some of `Connection` methods directly on the Pool object.
(by 1st1 in 1b3a847c for 39)

* Allow overriding codecs for builtin types on a connection.
(by elprans in 71de129b for 73)

* Add support for the text I/O fallback for arrays of unknown types.
(by elprans in a2e53ab0 for 82)

* Make the `Record` type available as `asyncpg.Record`.
(by elprans in d42608f9 for 93)

* pool: Track connections and prohibit using them after release.
(by 1st1 in 3bf6103e)

* Rollback any active transactions in `Connection.reset()`.
(by 1st1 in 0d19d962)

* Invalidate statement cache on schema changes affecting statement result.
(by elprans in 749d857a for 72)

* Use anonymous prepared statements when the cache is off.
(by 1st1 in a3e9cb45 for 76)

* Raise an error if connection is used after being closed.
(by 1st1 in 5ddd7fc9)

* Add Amazon Redshift detection.
(by elprans in 4fdc1dbc for 29)

* Add rudimentary server capability detection.
(by elprans in e8bb3dc0 for 87)


Bug fixes

* Handle exceptions in generators passed to `Connection.executemany()`.
(by elprans in 8d17eccb for 85)

* Shield `Pool.release()` from task cancellation.
(by elprans in 537c8c9f for 97)

* Fix inclusion of `DETAIL` and `HINT` in Postgres messages.
(by elprans in 2e346c12)

* Implement conistent handling of timeouts.
(by elprans in 1674dece)

* Make `timeout` arg of `Connection.executemany()` a keyword-only arg.
(by 1st1 in 424760d3)