From 594b526bcf32e307b963ea77f10c9720d9ca423f Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Thu, 20 Apr 2017 14:18:33 -0400 Subject: Modify message when partitioned table is added to publication Give a more specific error message than "xyz is not a table". Also document in CREATE PUBLICATION which kinds of relations are not supported. based on patch by Amit Langote --- doc/src/sgml/ref/create_publication.sgml | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index 0369b579c5c..521376ef4ba 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -75,6 +75,14 @@ CREATE PUBLICATION name Optionally, * can be specified after the table name to explicitly indicate that descendant tables are included. + + + 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. + -- cgit v1.2.3