[tryton-commits] [tryton] [7.8] Rename history sequence when the table is renamed

[Nicolas Évrard]

details:   https://code.tryton.org/tryton/commit/161de982b603
branch:    7.8
user:      Nicolas Évrard <ni...@b2ck.com>
date:      Tue Feb 10 18:21:47 2026 +0100
description:
        Rename history sequence when the table is renamed

        Just like in ff68233bdeb1 we need to also rename the history sequence 
name as
        the migration to identity relies on the sequence name including the 
table name.

        Closes #14598
        (grafted from 37e965ef7d10183ef37a2b627b25bc6366421122)
diffstat:

 trytond/trytond/backend/postgresql/table.py |  6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diffs (16 lines):

diff -r d00d22542d74 -r 161de982b603 trytond/trytond/backend/postgresql/table.py
--- a/trytond/trytond/backend/postgresql/table.py       Wed Feb 18 11:28:35 
2026 +0100
+++ b/trytond/trytond/backend/postgresql/table.py       Tue Feb 10 18:21:47 
2026 +0100
@@ -164,6 +164,12 @@
                 and not cls.table_exist(new_history)):
             cursor.execute('ALTER TABLE "%s" RENAME TO "%s"'
                 % (old_history, new_history))
+            # Migrate from 6.6: rename old history sequence
+            old_history_sequence = f'{old_name}__history' + '___id_seq'
+            new_history_sequence = f'{new_name}__history' + '___id_seq'
+            transaction.database.sequence_rename(
+                transaction.connection, old_history_sequence,
+                new_history_sequence)
 
     def column_exist(self, column_name):
         return column_name in self._columns