Tags: AMDmi3/psycopg2
Tags
Psycopg 2.7.5 released What's new in psycopg 2.7.5 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Allow non-ascii chars in namedtuple fields (regression introduced fixing 🎫`psycopg#211`). - Fixed adaptation of arrays of arrays of nulls (:ticket:`psycopg#325`). - Fixed building on Solaris 11 and derivatives such as SmartOS and illumos (:ticket:`psycopg#677`). - Maybe fixed building on MSYS2 (as reported in 🎫`psycopg#658`). - Allow string subclasses in connection and other places (:ticket:`psycopg#679`). - Don't raise an exception closing an unused named cursor (:ticket:`psycopg#716`). - Wheel package compiled against PostgreSQL 10.4 libpq and OpenSSL 1.0.2o.
Psycopg 2.7.4 released What's new in psycopg 2.7.4 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Moving away from installing the wheel package by default. Packages installed from wheel raise a warning on import. Added package ``psycopg2-binary`` to install from wheel instead (:ticket:`psycopg#543`). - Convert fields names into valid Python identifiers in `~psycopg2.extras.NamedTupleCursor` (:ticket:`psycopg#211`). - Fixed Solaris 10 support (:ticket:`psycopg#532`). - `cursor.mogrify()` can be called on closed cursors (:ticket:`psycopg#579`). - Fixed setting session characteristics in corner cases on autocommit connections (:ticket:`psycopg#580`). - Fixed `~psycopg2.extras.MinTimeLoggingCursor` on Python 3 (:ticket:`psycopg#609`). - Fixed parsing of array of points as floats (:ticket:`psycopg#613`). - Fixed `~psycopg2.__libpq_version__` building with libpq >= 10.1 (:ticket:`632`). - Fixed `~cursor.rowcount` after `~cursor.executemany()` with :sql:`RETURNING` statements (:ticket:`633`). - Fixed compatibility problem with pypy3 (:ticket:`psycopg#649`). - Wheel packages compiled against PostgreSQL 10.1 libpq and OpenSSL 1.0.2n. - Wheel packages for Python 2.6 no more available (support dropped from wheel building infrastructure).
Psycopg 2.7.3.2 released What's new in psycopg 2.7.3.2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Wheel package compiled against PostgreSQL 10.0 libpq and OpenSSL 1.0.2l (tickets psycopg#601, psycopg#602)
What's new in psycopg 2.7.3 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Restored default :sql:`timestamptz[]` typecasting to Python `!datetime`. Regression introduced in Psycopg 2.7.2 (🎫`psycopg#578`).
What's new in psycopg 2.7.2 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed inconsistent state in externally closed connections (:tickets:`psycopg#263, psycopg#311, psycopg#443`). Was fixed in 2.6.2 but not included in 2.7 by mistake. - Fixed Python exceptions propagation in green callback (:ticket:`psycopg#410`). - Don't display the password in `connection.dsn` when the connection string is specified as an URI (:ticket:`psycopg#528`). - Return objects with timezone parsing "infinity" :sql:`timestamptz` (🎫`psycopg#536`). - Dropped dependency on VC9 runtime on Windows binary packages (:ticket:`psycopg#541`). - Fixed segfault in `~connection.lobject()` when *mode*\=\ `!None` (:ticket:`psycopg#544`). - Fixed `~connection.lobject()` keyword argument *lobject_factory* (:ticket:`psycopg#545`). - Fixed `~psycopg2.extras.ReplicationCursor.consume_stream()` *keepalive_interval* argument (:ticket:`psycopg#547`). - Maybe fixed random import error on Python 3.6 in multiprocess environment (:ticket:`psycopg#550`). - Fixed random `!SystemError` upon receiving abort signal (:ticket:`psycopg#551`). - Accept `~psycopg2.sql.Composable` objects in `~psycopg2.extras.ReplicationCursor.start_replication_expert()` (:ticket:`554`). - Parse intervals returned as microseconds from Redshift (:ticket:`psycopg#558`). - Added `~psycopg2.extras.Json` `!prepare()` method to consider connection params when adapting (:ticket:`psycopg#562`). - `~psycopg2.errorcodes` map updated to PostgreSQL 10 beta 1.
Psycopg 2.7.1 released What's new in psycopg 2.7.1 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Ignore `!None` arguments passed to `~psycopg2.connect()` and `~psycopg2.extensions.make_dsn()` (:ticket:`psycopg#517`). - OpenSSL upgraded from major version 0.9.8 to 1.0.2 in the Linux wheel packages (:ticket:`psycopg#518`). - Fixed build with libpq versions < 9.3 (:ticket:`psycopg#520`).
Psycopg 2.7 released What's new in psycopg 2.7 ------------------------- New features: - Added `~psycopg2.sql` module to generate SQL dynamically (:ticket:`psycopg#308`). - Added :ref:`replication-support` (🎫`psycopg#322`). Main authors are Oleksandr Shulgin and Craig Ringer, who deserve a huge thank you. - Added `~psycopg2.extensions.parse_dsn()` and `~psycopg2.extensions.make_dsn()` functions (:tickets:`psycopg#321, psycopg#363`). `~psycopg2.connect()` now can take both *dsn* and keyword arguments, merging them together. - Added `~psycopg2.__libpq_version__` and `~psycopg2.extensions.libpq_version()` to inspect the version of the ``libpq`` library the module was compiled/loaded with (:tickets:`psycopg#35, psycopg#323`). - The attributes `~connection.notices` and `~connection.notifies` can be customized replacing them with any object exposing an `!append()` method (:ticket:`psycopg#326`). - Adapt network types to `ipaddress` objects when available. When not enabled, convert arrays of network types to lists by default. The old `!Inet` adapter is deprecated (:tickets:`psycopg#317, psycopg#343, psycopg#387`). - Added `~psycopg2.extensions.quote_ident()` function (:ticket:`psycopg#359`). - Added `~connection.get_dsn_parameters()` connection method (:ticket:`psycopg#364`). - `~cursor.callproc()` now accepts a dictionary of parameters (:ticket:`psycopg#381`). - Give precedence to `!__conform__()` over superclasses to choose an object adapter (:ticket:`psycopg#456`). - Using Python C API decoding functions and codecs caching for faster unicode encoding/decoding (:ticket:`psycopg#473`). - `~cursor.executemany()` slowness addressed by `~psycopg2.extras.execute_batch()` and `~psycopg2.extras.execute_values()` (:ticket:`psycopg#491`). - Added ``async_`` as an alias for ``async`` to support Python 3.7 where ``async`` will become a keyword (:ticket:`psycopg#495`). - Unless in autocommit, do not use :sql:`default_transaction_*` settings to control the session characteristics as it may create problems with external connection pools such as pgbouncer; use :sql:`BEGIN` options instead (🎫`psycopg#503`). - `~connection.isolation_level` is now writable and entirely separated from `~connection.autocommit`; added `~connection.readonly`, `~connection.deferrable` writable attributes. Bug fixes: - Fixed error caused by missing decoding `~psycopg2.extras.LoggingConnection` (:ticket:`psycopg#483`). - Fixed integer overflow in :sql:`interval` seconds (🎫`psycopg#512`). Other changes: - Dropped support for Python 2.5 and 3.1. - Dropped support for client library older than PostgreSQL 9.1 (but older server versions are still supported). - `~connection.isolation_level` doesn't read from the database but will return `~psycopg2.extensions.ISOLATION_LEVEL_DEFAULT` if no value was set on the connection. - Empty arrays no more converted into lists if they don't have a type attached (:ticket:`psycopg#506`)
Psycopg 2.7 beta 2 released What's new in psycopg 2.7 ------------------------- New features: - Added `~psycopg2.sql` module to generate SQL dynamically (:ticket:`psycopg#308`). - Added :ref:`replication-support` (🎫`psycopg#322`). Main authors are Oleksandr Shulgin and Craig Ringer, who deserve a huge thank you. - Added `~psycopg2.extensions.parse_dsn()` and `~psycopg2.extensions.make_dsn()` functions (:tickets:`psycopg#321, psycopg#363`). `~psycopg2.connect()` now can take both *dsn* and keyword arguments, merging them together. - Added `~psycopg2.__libpq_version__` and `~psycopg2.extensions.libpq_version()` to inspect the version of the ``libpq`` library the module was compiled/loaded with (:tickets:`psycopg#35, psycopg#323`). - The attributes `~connection.notices` and `~connection.notifies` can be customized replacing them with any object exposing an `!append()` method (:ticket:`psycopg#326`). - Adapt network types to `ipaddress` objects when available. When not enabled, convert arrays of network types to lists by default. The old `!Inet` adapter is deprecated (:tickets:`psycopg#317, psycopg#343, psycopg#387`). - Added `~psycopg2.extensions.quote_ident()` function (:ticket:`psycopg#359`). - Added `~connection.get_dsn_parameters()` connection method (:ticket:`psycopg#364`). - `~cursor.callproc()` now accepts a dictionary of parameters (:ticket:`psycopg#381`). - Give precedence to `!__conform__()` over superclasses to choose an object adapter (:ticket:`psycopg#456`). - Using Python C API decoding functions and codecs caching for faster unicode encoding/decoding (:ticket:`psycopg#473`). - `~cursor.executemany()` slowness addressed by `~psycopg2.extras.execute_batch()` and `~psycopg2.extras.execute_values()` (:ticket:`psycopg#491`). - Added ``async_`` as an alias for ``async`` to support Python 3.7 where ``async`` will become a keyword (:ticket:`psycopg#495`). - Unless in autocommit, do not use :sql:`default_transaction_*` settings to control the session characteristics as it may create problems with external connection pools such as pgbouncer; use :sql:`BEGIN` options instead (🎫`psycopg#503`). - `~connection.isolation_level` is now writable and entirely separated from `~connection.autocommit`; added `~connection.readonly`, `connection.deferrable` writable attributes. Bug fixes: - Fixed error caused by missing decoding `~psycopg2.extras.LoggingConnection` (:ticket:`psycopg#483`). Other changes: - Dropped support for Python 2.5 and 3.1. - Dropped support for client library older than PostgreSQL 9.1 (but older server versions are still supported). - `~connection.isolation_level` doesn't read from the database but will return `~psycopg2.extensions.ISOLATION_LEVEL_DEFAULT` if no value was set on the connection. - Empty arrays no more converted into lists if they don't have a type attached (:ticket:`psycopg#506`)
Psycopg 2.7 beta 1 released What's new in psycopg 2.7 ------------------------- New features: - Added `~psycopg2.sql` module to generate SQL dynamically (:ticket:`psycopg#308`). - Added :ref:`replication-support` (🎫`psycopg#322`). Main authors are Oleksandr Shulgin and Craig Ringer, who deserve a huge thank you. - Added `~psycopg2.extensions.parse_dsn()` and `~psycopg2.extensions.make_dsn()` functions (:tickets:`psycopg#321, psycopg#363`). `~psycopg2.connect()` now can take both *dsn* and keyword arguments, merging them together. - Added `~psycopg2.__libpq_version__` and `~psycopg2.extensions.libpq_version()` to inspect the version of the ``libpq`` library the module was compiled/loaded with (:tickets:`psycopg#35, psycopg#323`). - The attributes `~connection.notices` and `~connection.notifies` can be customized replacing them with any object exposing an `!append()` method (:ticket:`psycopg#326`). - Adapt network types to `ipaddress` objects when available. When not enabled, convert arrays of network types to lists by default. The old `!Inet` adapter is deprecated (:tickets:`psycopg#317, psycopg#343, psycopg#387`). - Added `~psycopg2.extensions.quote_ident()` function (:ticket:`psycopg#359`). - Added `~connection.get_dsn_parameters()` connection method (:ticket:`psycopg#364`). - `~cursor.callproc()` now accepts a dictionary of parameters (:ticket:`psycopg#381`). - Give precedence to `!__conform__()` over superclasses to choose an object adapter (:ticket:`psycopg#456`). - Using Python C API decoding functions and codecs caching for faster unicode encoding/decoding (:ticket:`psycopg#473`). - `~cursor.executemany()` slowness addressed by `~psycopg2.extras.execute_batch()` and `~psycopg2.extras.execute_values()` (:ticket:`psycopg#491`). - Added ``async_`` as an alias for ``async`` to support Python 3.7 where ``async`` will become a keyword (:ticket:`psycopg#495`). - Unless in autocommit, do not use :sql:`default_transaction_*` settings to control the session characteristics as it may create problems with external connection pools such as pgbouncer; use :sql:`BEGIN` options instead (🎫`psycopg#503`). Bug fixes: - Throw an exception trying to pass ``NULL`` chars as parameters (:ticket:`psycopg#420`). - Make `~psycopg2.extras.Range` objects picklable (:ticket:`psycopg#462`). - Fixed error caused by missing decoding `~psycopg2.extras.LoggingConnection` (:ticket:`psycopg#483`). Other changes: - Dropped support for Python 2.5 and 3.1. - Dropped support for client library older than PostgreSQL 9.1 (but older server versions are still supported). - `~connection.isolation_level` doesn't read from the database but will return `~psycopg2.extensions.ISOLATION_LEVEL_DEFAULT` if no value was set on the connection. - `~connection.set_isolation_level()` will throw an exception if executed inside a transaction; previously it would have silently rolled it back. - Empty arrays no more converted into lists if they don't have a type attached (:ticket:`psycopg#506`)
PreviousNext