Conditional column filtering with pglogical replication

Поиск
Список
Период
Сортировка
От PALAYRET Jacques
Тема Conditional column filtering with pglogical replication
Дата
Msg-id 1798752798.21016829.1603460088042.JavaMail.zimbra@meteo.fr
обсуждение исходный текст
Ответы Re: Conditional column filtering with pglogical replication  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
Список pgsql-general
Hello,

With PgLogical extension, I have tested the possibility of column filtering (columns) and row filtering (row_filter).
But is there a way to do a conditional column filtering ?
I mean a way to filter a column based on a predicate, with pglogical (so the filtered values won’t arrive on subscribers).
For example, with a replicated table t(a integer as Primary Key, b numeric, c integer, d text), I would like to filter the column b when c between 10 and 20.

Regards
----- Météo-France -----
PALAYRET JACQUES
DCSC/MBD
jacques.palayret@meteo.fr
Fixe : +33 561078319

В списке pgsql-general по дате отправления:

Предыдущее
От: Philip Semanchuk
Дата:
Сообщение: Re: postgres materialized view refresh performance
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Hot backup in PostgreSQL