django.git/django/db/backends/postgresql/schema.py, branch main

Fixed #21961 -- Added support for database-level delete options for ForeignKey.

2025-10-18T13:03:50Z

Thanks Simon Charette for pair programming. Co-authored-by: Nick Stefan Co-authored-by: Akash Kumar Sen <71623442+Akash-Kumar-Sen@users.noreply.github.com> Co-authored-by: Simon Charette

Fixed #36165 -- Made PostgreSQL's SchemaEditor._delete_index_sql() respect the "sql" argument.

2025-02-05T23:15:39Z

This is a follow up of bd366ca2aeffa869b7dbc0b0aa01caea75e6dc31. Thank you Daniel Finch for the report.

Fixed #35969 -- Disallowed specifying a USING clause for altered generated field.

2024-12-17T10:27:25Z

PostgreSQL versions 16.5 and above no longer permit the use of a USING clause when changing the type of a generated column.

Fixed #35180 -- Recreated PostgreSQL _like indexes when changing between TextField and CharField field types.

2024-10-31T05:37:14Z

Reverted "Fixed #28646 -- Prevented duplicate index when unique is set to True on PostgreSQL."

2024-08-01T07:25:33Z

This reverts commit 9cf9c796be8dd53bc3b11355ff39d65c81d7be6d due to a crash on Oracle as it didn't allow multiple indexes on the same field.

Fixed #28646 -- Prevented duplicate index when unique is set to True on PostgreSQL.

2024-07-30T15:27:10Z

Removed unused _alter_column_collation_sql() in PostgreSQL DatabaseSchemaEditor.

2024-03-25T07:50:26Z

Unused since ae0899be0d787fbfc5f5ab2b18c5a8219d822d2b.

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

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

Fixed #34932 -- Restored varchar_pattern_ops/text_pattern_ops index creation when deterministic collaction is set.

2023-10-30T06:37:40Z

Regression in f3f9d03edf17ccfa17263c7efa0b1350d1ac9278 (4.2) and 8ed25d65ea7546fafd808086fa07e7e5bb5428fc (5.0).

Fixed #34553 -- Fixed improper % escaping of literal in constraints.

2023-05-10T15:25:57Z

Proper escaping of % in string literals used when defining constaints was attempted (a8b3f96f6) by overriding quote_value of Postgres and Oracle schema editor. The same approach was used when adding support for constraints to the MySQL/MariaDB backend (1fc2c70). Later on it was discovered that this approach was not appropriate and that a preferable one was to pass params=None when executing the constraint creation DDL to avoid any form of interpolation in the first place (42e8cf47). When the second patch was applied the corrective of the first were not removed which caused % literals to be unnecessary doubled. This flew under the radar because the existings test were crafted in a way that consecutive %% didn't catch regressions. This commit introduces an extra test for __exact lookups which highlights more adequately % doubling problems but also adjust a previous __endswith test to cover % doubling problems (%\% -> %%\%%). Thanks Thomas Kolar for the report. Refs #32369, #30408, #30593.