Mercurial > libervia-pubsub
view .hgtags @ 433:920440200570
PostgreSQL: don't use `regconfig` and `GENERATED` column anymore
/!\ pgsql schema needs to be updated /!\
/!\ Minimal PostgreSQL required version is back to 9.5 /!\
`regconfig` is using system table, and `pg_upgrade` can't handle that, causing trouble
when moving to a new major version of PostgreSQL.
To work around this, the `data_fts_cfg` column type in `items` has been changed from
`regconfig` to `text`.
GENERATED column can't be used with type casting to `regconfig`, so the data_fts column is
now generated with a trigger. As a result, the minimal requirement of PostgreSQL 12 is not
necessary anymore.
author | Goffi <goffi@goffi.org> |
---|---|
date | Thu, 14 Jan 2021 17:59:23 +0100 |
parents | 4b5d4da54d9e |
children | af167e95527c |
line wrap: on
line source
b2149e448465d54e39bb8892ba9ded3313510738 idavoll-0.5.0 e289636ccc4f9e3690879aaf7b9bb5f2674c3fc8 idavoll-0.7.3 560b6cdc50b20d7590a70b0311d4781e3296c589 0.1.0 232002e132dbf9c7563d9f78f4b5e2bcdc2764de 0.1.1 642dffb9d6f1e7b2e7d5e9cb6ba17b6950fdf0bb 0.2.0 0861da6975b57dcaa1c69b2833232fe191346f87 0.3.0