Issue 10858

Title
Use JSONB by default on PostgreSQL
Priority
feature
Status
resolved
Nosy list
ced, reviewbot, roundup-bot
Assigned to
ced
Keywords
review

Created on 2021-10-15.10:29:50 by ced, last changed 2 months ago by roundup-bot.

Messages

New changeset 396e7598ed88 by Cédric Krier in branch 'default':
Use JSONB to store Dict field on PostgreSQL backend
https://hg.tryton.org/tryton-env/rev/396e7598ed88
New changeset 70eb48aa2f0a by Cédric Krier in branch 'default':
Use JSONB to store Dict field on PostgreSQL backend
https://hg.tryton.org/trytond/rev/70eb48aa2f0a
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2021-10-15.10:29:49

When Dict fields were added, not all the supported PostgreSQL version had the support for JSONB field. It was added in version 9.2 (which is now unsupported since November 9, 2017).
I think it is time to use by default JSONB but we must keep support for existing column that are created as TEXT.
Also this will prevent annoying migration warning between TEXT and JSONB when DB admin has modified the type.

History
Date User Action Args
2021-11-08 19:27:28roundup-botsetmessages: + msg71556
2021-11-08 19:27:24roundup-botsetmessages: + msg71555
nosy: + roundup-bot
status: testing -> resolved
2021-10-15 11:02:10reviewbotsetmessages: + msg71005
nosy: + reviewbot
2021-10-15 10:30:29cedsetkeyword: + review
reviews: 379371002
status: in-progress -> testing
2021-10-15 10:29:50cedcreate

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