Fixed #31473 -- Made sql_flush() use RESTART IDENTITY to reset sequences on PostgreSQL.

The sql_flush() positional argument sequences is replaced by the boolean
keyword-only argument reset_sequences. This ensures that the old
function signature can't be used by mistake when upgrading Django. When
the new argument is True, the sequences of the truncated tables will
reset. Using a single boolean value, rather than a list, allows making a
binary yes/no choice as to whether to reset all sequences rather than a
working on a completely different set.

1 files changed, 7 insertions, 0 deletions

diff --git a/docs/releases/3.1.txt b/docs/releases/3.1.txt
index 55f539d534..3ec3afcf3a 100644
--- a/docs/releases/3.1.txt
+++ b/docs/releases/3.1.txt
@@ -519,6 +519,13 @@ backends.
 * ``DatabaseClient.runshell()`` now requires an additional ``parameters``
   argument as a list of extra arguments to pass on to the command-line client.
 
+* The ``sequences`` positional argument of ``DatabaseOperations.sql_flush()``
+  is replaced by the boolean keyword-only argument ``reset_sequences``. If
+  ``True``, the sequences of the truncated tables will be reset.
+
+* The ``allow_cascade`` argument of ``DatabaseOperations.sql_flush()`` is now a
+  keyword-only argument.
+
 Dropped support for MariaDB 10.1
 --------------------------------