Optionally, <literal>*</> can be specified after the table name to

explicitly indicate that descendant tables are included.

</para>

<para>

Only persistent base tables can be part of a publication. Temporary

tables, unlogged tables, foreign tables, materialized views, regular

views, and partitioned tables cannot be part of a publication. To

replicate a partitioned table, add the individual partitions to the

publication.

</para>

</listitem>

</varlistentry>

check_publication_add_relation(Relationtargetrel)

{

if (RelationGetForm(targetrel)->relkind==RELKIND_PARTITIONED_TABLE)

ereport(ERROR,

(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),

errmsg("\"%s\" is a partitioned table",

RelationGetRelationName(targetrel)),

errdetail("Adding partitioned tables to publications is not supported."),

errhint("You can add the table partitions individually.")));

if (RelationGetForm(targetrel)->relkind!=RELKIND_RELATION)

ereport(ERROR,

CREATE TABLE testpub_tbl1 (id serial primary key, data text);

CREATE TABLE pub_test.testpub_nopk (foo int, bar int);

CREATE VIEW testpub_view AS SELECT 1;

CREATE TABLE testpub_parted (a int) PARTITION BY LIST (a);

CREATE PUBLICATION testpub_foralltables FOR ALL TABLES WITH (nopublish delete, nopublish update);

ALTER PUBLICATION testpub_foralltables WITH (publish update);

CREATE TABLE testpub_tbl2 (id serial primary key, data text);

ALTER PUBLICATION testpub_default ADD TABLE testpub_view;

ERROR: "testpub_view" is not a table

DETAIL: Only tables can be added to publications.

-- fail - partitioned table

ALTER PUBLICATION testpub_fortbl ADD TABLE testpub_parted;

ERROR: "testpub_parted" is a partitioned table

DETAIL: Adding partitioned tables to publications is not supported.

HINT: You can add the table partitions individually.

ALTER PUBLICATION testpub_default ADD TABLE testpub_tbl1;

ALTER PUBLICATION testpub_default SET TABLE testpub_tbl1;

ALTER PUBLICATION testpub_default ADD TABLE pub_test.testpub_nopk;

DROP PUBLICATION testpub2;

SET ROLE regress_publication_user;

REVOKE CREATE ON DATABASE regression FROM regress_publication_user2;

DROP TABLE testpub_parted;

DROP VIEW testpub_view;

DROP TABLE testpub_tbl1;

\dRp+ testpub_default

CREATETABLEtestpub_tbl1 (idserialprimary key, datatext);

CREATETABLEpub_test.testpub_nopk (fooint, barint);

CREATEVIEWtestpub_viewASSELECT1;

CREATETABLEtestpub_parted (aint) PARTITION BY LIST (a);

CREATE PUBLICATION testpub_foralltables FOR ALL TABLES WITH (nopublishdelete, nopublishupdate);

ALTER PUBLICATION testpub_foralltables WITH (publishupdate);

ALTER PUBLICATION testpub_default ADD TABLE testpub_view;

ALTER PUBLICATION testpub_fortbl ADD TABLE testpub_parted;

ALTER PUBLICATION testpub_default ADD TABLE testpub_tbl1;

ALTER PUBLICATION testpub_defaultSET TABLE testpub_tbl1;

SET ROLE regress_publication_user;

REVOKE CREATEON DATABASE regressionFROM regress_publication_user2;

DROPTABLE testpub_parted;

DROPVIEW testpub_view;

DROPTABLE testpub_tbl1;