commit75b1521dae1ff1fde17fda2e30e591f2e5d64b6a Author: Tomas Vondra <tomas.vondra@postgresql.org> Date: Thu Mar 2418:20:212022 +0100
Add decoding ofsequencesto built-inreplication
This commit adds support for decoding ofsequencesto the built-in replication (the infrastructure was added bycommit0da92dc530).
The syntax and behavior mostly mimics handling oftables, i.e. a publication may be defined asFORALLSEQUENCES (replicating all sequencesin a database), FORALLSEQUENCESINSCHEMA (replicating allsequencesin a particular schema) or individual sequences.
To publish sequence modifications, the publication has toinclude 'sequence' action. The protocol is extended with a new message, describing sequence increments.
A newsystemview pg_publication_sequences lists all the sequences added to a publication, both directly and indirectly. Various psql commands (\d and \dRp) are improved toalso display publications including a given sequence, orsequences included in a publication.
Author: Tomas Vondra, Cary Huang Reviewed-by: Peter Eisentraut, Amit Kapila, Hannu Krosing, Andres Freund, Petr Jelinek Discussion: https://postgr.es/m/d045f3c2-6cfb-06d3-5540-e63c320df8bc@enterprisedb.com Discussion: https://postgr.es/m/1710ed7e13b.cd7177461430746.3372264562543607781@highgo.ca