Mercurial > libervia-pubsub
view doc/index.rst @ 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 | 105a0772eedd |
children |
line wrap: on
line source
.. SàT PubSub documentation master file, created by sphinx-quickstart on Wed Jul 24 08:06:59 2019. You can adapt this file completely to your liking, but it should at least contain the root `toctree` directive. SàT PubSub documentation ======================== SàT PubSub is a XMPP PubSub service component (XEP-0060) It's based on Ralph Meijer's Idavoll, and provides special features necessary for the « Salut à Toi » project (https://salut-a-toi.org) , but it can also be used for any other XMPP project. The use of a standard external component allow to use this features with most XMPP servers. One of the main addition is fine access tuning for PubSub, which allow the publication of items for only some groups, even if the entire node is open. The protocol is explained on http://www.goffi.org/post/2012/06/24/Fine-access-tuning-for-PubSub for the moment, and a protoxep should be proposed to the XSF in the future… .. toctree:: :maxdepth: 3 :caption: Contents: installation.rst Indices and tables ================== * :ref:`genindex` * :ref:`modindex` * :ref:`search`