Drop table with cascade fails on postgresql
We have a custom module that drops a table on a migration and this causes the following crash:
Try to re-run: trytond.py --update=module
If it doesn't work, update records and execute manually:
ALTER TABLE "account_tax_template" ALTER COLUMN "account" SET NOT NULL
28207 140347190187840 [2021-04-13 10:01:51,315] INFO trytond.modules account_timeline:register account.tax
Traceback (most recent call last):
File "/home/pokoli/.virtualenvs/60_migration/bin/trytond-admin", line 7, in <module>
exec(compile(f.read(), __file__, 'exec'))
File "/home/pokoli/projectes/60_migration/trytond/bin/trytond-admin", line 23, in <module>
admin.run(options)
File "/home/pokoli/projectes/60_migration/trytond/trytond/admin.py", line 53, in run
pool.init(update=options.update, lang=list(lang),
File "/home/pokoli/projectes/60_migration/trytond/trytond/pool.py", line 164, in init
restart = not load_modules(
File "/home/pokoli/projectes/60_migration/trytond/trytond/modules/__init__.py", line 437, in load_modules
_load_modules(update)
File "/home/pokoli/projectes/60_migration/trytond/trytond/modules/__init__.py", line 405, in _load_modules
load_module_graph(graph, pool, update, lang)
File "/home/pokoli/projectes/60_migration/trytond/trytond/modules/__init__.py", line 238, in load_module_graph
cls.__register__(module)
File "/home/pokoli/projectes/60_migration/trytond/trytond/modules/account_timeline/tax.py", line 94, in __register__
table.drop_table('tax.account', 'tax_account', cascade=True)
File "/home/pokoli/projectes/60_migration/trytond/trytond/backend/postgresql/table.py", line 523, in drop_table
query = query + ' CASCADE'
TypeError: unsupported operand type(s) for +: 'Composed' and 'str'