Issue 7331

Title
Do not use temporary column to alter size
Priority
feature
Status
resolved
Superseder
Make use of psycopg's sql module in backend (issue 10245)
Nosy list
ced, reviewbot, roundup-bot, xavier
Assigned to
ced
Keywords
easy, review

Created on 2018-04-07.19:14:17 by ced, last changed 2 months ago by roundup-bot.

Messages

New changeset 5bff7b85e3bb by Cédric Krier in branch 'default':
Alter column type to change size on postgresql table
https://hg.tryton.org/tryton-env/rev/5bff7b85e3bb
New changeset ec2fc6da64aa by Cédric Krier in branch 'default':
Alter column type to change size on postgresql table
https://hg.tryton.org/trytond/rev/ec2fc6da64aa
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2021-04-05.17:38:14

Indeed the query should follow the syntax of issue10245.

Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2018-04-07.19:14:17
The query to alter the size on postgresql backend could use:

ALTER TABLE ... ALTER COLUMN ... TYPE ...
History
Date User Action Args
2021-04-13 01:46:19roundup-botsetmessages: + msg66533
2021-04-13 01:46:10roundup-botsetmessages: + msg66531
nosy: + roundup-bot
status: in-progress -> resolved
2021-04-13 01:41:23cedsetassignedto: ced
2021-04-05 17:38:14cedsetmessages: + msg66109
superseder: + Make use of psycopg's sql module in backend
2020-11-24 13:13:35xaviersetassignedto: xavier -> (no value)
status: testing -> in-progress
2020-11-04 10:22:30xaviersetstatus: chatting -> testing
2020-11-04 09:38:08reviewbotsetmessages: + msg61634
2020-11-02 11:03:56reviewbotsetmessages: + msg61588
2020-11-02 10:40:04xaviersetassignedto: xavier
nosy: + xavier
2020-11-02 10:10:58reviewbotsetmessages: + msg61587
nosy: + reviewbot
status: unread -> chatting

Showing 10 items. Show all history (warning: this could be VERY long)