django.git/django/db/backends/postgresql/base.py, branch 5.2.12

Fixed #35688 -- Restored timezone and role setters to be PostgreSQL DatabaseWrapper methods.

2024-08-28T22:25:07Z

Following the addition of PostgreSQL connection pool support in Refs #33497, the methods for configuring the database role and timezone were moved to module-level functions. This change prevented subclasses of DatabaseWrapper from overriding these methods as needed, for example, when creating wrappers for other PostgreSQL-based backends. Thank you Christian Hardenberg for the report and to Florian Apolloner and Natalia Bidart for the review. Regression in fad334e1a9b54ea1acb8cce02a25934c5acfe99f. Co-authored-by: Natalia <124304+nessita@users.noreply.github.com>

Refs #33497 -- Added connection pool support for PostgreSQL.

2024-03-01T08:01:18Z

Co-authored-by: Florian Apolloner Co-authored-by: Ran Benita

Refs #34200 -- Removed unnecessary check in DatabaseWrapper.ensure_role() on PostgreSQL.

2024-02-26T09:53:47Z

ensure_role() is only called in init_connection_state() where a new connection is established.

Simplified using DATABASES["OPTIONS"].

2024-02-23T06:49:43Z

DATABASES["OPTIONS"] are always configured.

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

https://github.com/psf/black/releases/tag/24.1.0

Fixed #35028 -- Disabled server-side bindings for named cursors on psycopg >= 3.

2024-01-12T20:40:18Z

While we provide a `cursor_factory` based on the value of the `server_side_bindings` option to `psycopg.Connection` it is ignored by the `cursor` method when `name` is specified for `QuerySet.iterator()` usage and it causes the usage of `psycopg.ServerCursor` which performs server-side bindings. Since the ORM doesn't generates SQL that is suitable for server-side bindings when dealing with parametrized expressions a specialized cursor must be used to allow server-side cursors to be used with client-side bindings. Thanks Richard Ebeling for the report. Thanks Florian Apolloner and Daniele Varrazzo for reviews.

Fixed #34470 -- Enforced UTF-8 encoding on PostgreSQL.

2023-04-07T08:11:41Z

Regression in 6a2165816394ab4bb259f6171e82417e098e97a6.

Fixed #34466 -- Reallowed setting cursor_factory in DATABASES["options"] on PostgreSQL.

2023-04-07T06:02:34Z

Regression in 09ffc5c1212d4ced58b708cbbf3dfbfb77b782ca.

Refs #33476 -- Applied Black's 2023 stable style.

2023-02-01T10:04:38Z

Black 23.1.0 is released which, as the first release of the year, introduces the 2023 stable style. This incorporates most of last year's preview style. https://github.com/psf/black/releases/tag/23.1.0

Fixed #34255 -- Made PostgreSQL backend use client-side parameters binding with psycopg version 3.

2023-01-17T07:24:08Z

Thanks Guillaume Andreu Sabater for the report. Co-authored-by: Florian Apolloner