Horton

Re: logical decoding and replication of sequences

Euler Taveira <euler@eulerto.com>

View thread View on postgr.es
From: "Euler Taveira" <euler@eulerto.com>
To: "Tomas Vondra" <tomas.vondra@enterprisedb.com>, "Amit Kapila" <amit.kapila16@gmail.com>
Cc: "Peter Eisentraut" <peter.eisentraut@enterprisedb.com>, "Petr Jelinek" <petr.jelinek@enterprisedb.com>, "PostgreSQL Hackers" <pgsql-hackers@lists.postgresql.org>
Date: 2022-02-23T22:05:58Z
Lists: pgsql-hackers 
On Wed, Feb 23, 2022, at 4:18 PM, Tomas Vondra wrote:
> On 2/23/22 18:33, Euler Taveira wrote:
> > On Wed, Feb 23, 2022, at 1:07 PM, Tomas Vondra wrote:
> >> Maybe, but I don't think it's very common to have that many
> >> schemas added to the same publication. And it probably does not
> >> make much difference whether you have 1000 or 2000 items in the
> >> list - either both are acceptable or unacceptable, I think.
> >
> > Wouldn't it confuse users? Hey, duplicate publication. How? Wait.
> > Doh.
> > 
> 
> I don't follow. Duplicate publications? This talks about rows in
> pg_publication_namespace, not pg_publication.
I was referring to

  Publications:
      "testpub_schemas" (sequences)
      "testpub_schemas" (tables)

versus

  Publications:
      "testpub_schemas" (tables, sequences)

I prefer the latter.


--
Euler Taveira
EDB   https://www.enterprisedb.com/

Commits

  1. Fix cache invalidation bug in recovery_prefetch.

  2. Revert "Logical decoding of sequences"

  3. Minor improvements in sequence decoding code and docs

  4. Handle sequences in preprocess_pubobj_list

  5. Update tab-completion for CREATE PUBLICATION with sequences

  6. Add decoding of sequences to built-in replication

  7. Stabilize test_decoding touching with sequences

  8. Call ReorderBufferProcessXid from sequence_decode

  9. Add decoding of sequences to test_decoding

  10. Replace Test::More plans with done_testing

  11. Logical decoding of sequences

  12. Respect permissions within logical replication.