create publication descendant tables

From: Brian Faherty <anothergenericuser(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: create publication descendant tables
Date: 2018-03-19 13:23:32
Message-ID: CAMLsqiQ=vROQm=w141JOVDJ=KqDXQASoqjXnx1JmjZHzhfmmGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

I was looking at the `CREATE PUBLICATION FOR TABLE table *;` and I ended up
with a few questions.

1.) Can '*' ever be used since it includes the parent table along with the
child which then results in a error being thrown about parent tables not
being able to be replicated?
2.) Will it only work on current descendants or will it also work on future
descendants?

For quick reference:
https://www.postgresql.org/docs/10/static/sql-createpublication.html

--
Brian Faherty

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-03-19 15:29:32 coder
Previous Message Greg k 2018-03-19 05:51:32 Re: Postgres 10 and the pg_ctl "--wait" option