django.git/tests/backends/postgresql, branch main

Fixed #37075 -- Allowed overriding the PostgreSQL pool's "check" callable.

2026-04-30T23:52:11Z

Setting "check" in OPTIONS["pool"] previously raised TypeError because the PostgreSQL backend always passed check= to ConnectionPool() and unpacked **pool_options on top, regardless of CONN_HEALTH_CHECKS. The user's callable now takes precedence via setdefault(); pool_options is copied first to avoid mutating the user's settings dict.

Fixed #36822 -- Added parameter limit for PostgreSQL with server-side binding.

2026-01-16T14:15:53Z

Refs #33647 -- Fixed silent data truncation in bulk_create on Postgres.

2025-12-31T15:41:55Z

Regression in a16eedcf9c69d8a11d94cac1811018c5b996d491. The UNNEST strategy is affected by the same problem bulk_update has wrt/ to silent data truncation due to its usage of db_type which always returns a parametrized subtype.

Refs #24928 -- Added introspection support for PostgreSQL HStoreField.

2025-11-14T12:36:15Z

Fixed #36623 -- Dropped support for PostgreSQL 14 and PostGIS 3.1.

2025-10-03T21:12:57Z

Refs #36500 -- Rewrapped long docstrings and block comments via a script.

2025-07-23T23:17:55Z

Rewrapped long docstrings and block comments to 79 characters + newline using script from https://github.com/medmunds/autofix-w505.

Fixed #36502 -- Restored UNNEST strategy for foreign key bulk inserts on PostgreSQL.

2025-07-10T16:33:00Z

Regression in 764af7a3d6c0b543dcf659a2c327f214da768fe4.

Fixed #36088 -- Avoided unnecessary DEFAULT usage on bulk_create().

2025-02-01T17:43:10Z

When all values of a field with a db_default are DatabaseDefault, which is the case most of the time, there is no point in specifying explicit DEFAULT for all INSERT VALUES as that's what the database will do anyway if not specified. In the case of PostgreSQL doing so can even be harmful as it prevents the usage of the UNNEST strategy and in the case of Oracle, which doesn't support the usage of the DEFAULT keyword, it unnecessarily requires providing literal db defaults. Thanks Lily Foote for the review.

Fixed #35936 -- Used unnest for bulk inserts on Postgres when possible.

2024-12-11T12:56:18Z

This should make bulk_create significantly faster on Postgres when provided only literal values. Thanks James Sewell for writing about this technique, Tom Forbes for validating the performance benefits, David Sanders and Mariusz Felisiak for the review.

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>