chango.git/django/db/backends/postgresql/features.py, branch devmain

Fixed #36492 -- Restored exact boolean lookup against literals on SQLite.

2026-06-03T20:57:18Z

Performance regression in 37e6c5b on SQLite. Just like MySQL, and presumably Oracle, which don't have a native boolean type and incidently store booleans in integer columns, indices on such columns cannot be used when explicit boolean literal equalities are omitted. Adapt the logic introduced by refs #32691 for MySQL to be used for all backends that don't support native boolean fields instead of special casing MySQL, SQLite, and Oracle in their own special way. Note that review of this work surfaced that SQLite's query planner also cannot make use of indices when dealing with expressions of form WHERE NOT (indexed_bool_field = false) but that's a long standing problem unrelated to the restorative work performed in this patch. Thanks Klaas van Schelven for the report.

Refs #36795 -- Removed unnecessary prohibits_dollar_signs_in_column_aliases feature flag.

2026-03-19T16:24:17Z

Now that user provided aliases are systematically quoted there is no need to disallow the usage of the dollar sign on Postgres.

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

2026-01-16T14:15:53Z

Refs #36735 -- Supported shift parameter for UUID7 on PostgreSQL.

2025-12-12T16:50:36Z

Fixed #36735 -- Added UUID4 and UUID7 database functions.

2025-12-12T16:17:08Z

Co-authored-by: Mariusz Felisiak

Added DatabaseFeatures.prohibits_dollar_signs_in_column_aliases.

2025-12-04T16:37:22Z

This is also applicable on CockroachDB.

Fixed #24920 -- Added support for DecimalField with no precision.

2025-11-17T12:43:47Z

Thanks Lily for the review.

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

2025-10-03T21:12:57Z

Fixed #36277 -- Fixed DatabaseFeatures.supports_virtual_generated_columns on PostgreSQL 18+.

2025-09-29T08:54:27Z

Refs #27222 -- Refreshed GeneratedFields values on save() initiated update.

2025-09-13T22:27:49Z

This required implementing UPDATE RETURNING machinery that heavily borrows from the INSERT one.