[tryton-commits] [tryton] [7.8] Convert index expression to string to instantiate...

[Cédric Krier]

details:   https://code.tryton.org/tryton/commit/5751e5b6a5ae
branch:    7.8
user:      Cédric Krier <c...@b2ck.com>
date:      Sat Jan 24 08:51:39 2026 +0100
description:
        Convert index expression to string to instantiate psycopg2 SQL

        Closes #14487
        (grafted from 0c2a2477e2b2eb6c24821a084d563f37527607d4)
diffstat:

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

diffs (15 lines):

diff -r 0a84460d606a -r 5751e5b6a5ae trytond/trytond/backend/postgresql/table.py
--- a/trytond/trytond/backend/postgresql/table.py       Tue Jan 13 16:50:08 
2026 +0100
+++ b/trytond/trytond/backend/postgresql/table.py       Sat Jan 24 08:51:39 
2026 +0100
@@ -653,9 +653,9 @@
         else:
             expression_str = str(expression)
             if expression_str.startswith('(') and expression_str.endswith(')'):
-                variables['expression'] = SQL(expression)
+                variables['expression'] = SQL(expression_str)
             else:
-                variables['expression'] = SQL(f'({expression})')
+                variables['expression'] = SQL(f'({expression_str})')
         if usage.options.get('collation'):
             variables['collate'] = SQL('COLLATE {}').format(
                 usage.options['collation'])