PostgreSQL Source Code  git master
pg_publication.h
Go to the documentation of this file.
1 /*-------------------------------------------------------------------------
2  *
3  * pg_publication.h
4  * definition of the "publication" system catalog (pg_publication)
5  *
6  * Portions Copyright (c) 1996-2021, PostgreSQL Global Development Group
7  * Portions Copyright (c) 1994, Regents of the University of California
8  *
9  * src/include/catalog/pg_publication.h
10  *
11  * NOTES
12  * The Catalog.pm module reads this file and derives schema
13  * information.
14  *
15  *-------------------------------------------------------------------------
16  */
17 #ifndef PG_PUBLICATION_H
18 #define PG_PUBLICATION_H
19 
20 #include "catalog/genbki.h"
21 #include "catalog/objectaddress.h"
22 #include "catalog/pg_publication_d.h"
23 
24 /* ----------------
25  * pg_publication definition. cpp turns this into
26  * typedef struct FormData_pg_publication
27  * ----------------
28  */
29 CATALOG(pg_publication,6104,PublicationRelationId)
30 {
31  Oid oid; /* oid */
32 
33  NameData pubname; /* name of the publication */
34 
35  Oid pubowner BKI_LOOKUP(pg_authid); /* publication owner */
36 
37  /*
38  * indicates that this is special publication which should encompass all
39  * tables in the database (except for the unlogged and temp ones)
40  */
41  bool puballtables;
42 
43  /* true if inserts are published */
44  bool pubinsert;
45 
46  /* true if updates are published */
47  bool pubupdate;
48 
49  /* true if deletes are published */
50  bool pubdelete;
51 
52  /* true if truncates are published */
53  bool pubtruncate;
54 
55  /* true if partition changes are published using root schema */
56  bool pubviaroot;
58 
59 /* ----------------
60  * Form_pg_publication corresponds to a pointer to a tuple with
61  * the format of pg_publication relation.
62  * ----------------
63  */
65 
66 DECLARE_UNIQUE_INDEX_PKEY(pg_publication_oid_index, 6110, PublicationObjectIndexId, on pg_publication using btree(oid oid_ops));
67 DECLARE_UNIQUE_INDEX(pg_publication_pubname_index, 6111, PublicationNameIndexId, on pg_publication using btree(pubname name_ops));
68 
69 typedef struct PublicationActions
70 {
71  bool pubinsert;
72  bool pubupdate;
73  bool pubdelete;
76 
77 typedef struct Publication
78 {
80  char *name;
81  bool alltables;
82  bool pubviaroot;
85 
86 typedef struct PublicationRelInfo
87 {
90 
91 extern Publication *GetPublication(Oid pubid);
92 extern Publication *GetPublicationByName(const char *pubname, bool missing_ok);
93 extern List *GetRelationPublications(Oid relid);
94 
95 /*---------
96  * Expected values for pub_partopt parameter of GetRelationPublications(),
97  * which allows callers to specify which partitions of partitioned tables
98  * mentioned in the publication they expect to see.
99  *
100  * ROOT: only the table explicitly mentioned in the publication
101  * LEAF: only leaf partitions in given tree
102  * ALL: all partitions in given tree
103  */
104 typedef enum PublicationPartOpt
105 {
110 
111 extern List *GetPublicationRelations(Oid pubid, PublicationPartOpt pub_partopt);
112 extern List *GetAllTablesPublications(void);
113 extern List *GetAllTablesPublicationRelations(bool pubviaroot);
114 extern List *GetPublicationSchemas(Oid pubid);
115 extern List *GetSchemaPublications(Oid schemaid);
116 extern List *GetSchemaPublicationRelations(Oid schemaid,
117  PublicationPartOpt pub_partopt);
119  PublicationPartOpt pub_partopt);
121  PublicationPartOpt pub_partopt,
122  Oid relid);
123 
124 extern bool is_publishable_relation(Relation rel);
126  bool if_not_exists);
127 extern ObjectAddress publication_add_schema(Oid pubid, Oid schemaid,
128  bool if_not_exists);
129 
130 extern Oid get_publication_oid(const char *pubname, bool missing_ok);
131 extern char *get_publication_name(Oid pubid, bool missing_ok);
132 
133 
134 #endif /* PG_PUBLICATION_H */
#define BKI_LOOKUP(catalog)
Definition: genbki.h:46
DECLARE_UNIQUE_INDEX(pg_publication_pubname_index, 6111, PublicationNameIndexId, on pg_publication using btree(pubname name_ops))
DECLARE_UNIQUE_INDEX_PKEY(pg_publication_oid_index, 6110, PublicationObjectIndexId, on pg_publication using btree(oid oid_ops))
List * GetPublicationSchemas(Oid pubid)
Publication * GetPublicationByName(const char *pubname, bool missing_ok)
List * GetSchemaPublications(Oid schemaid)
Publication * GetPublication(Oid pubid)
List * GetRelationPublications(Oid relid)
ObjectAddress publication_add_schema(Oid pubid, Oid schemaid, bool if_not_exists)
CATALOG(pg_publication, 6104, PublicationRelationId)
struct PublicationRelInfo PublicationRelInfo
FormData_pg_publication
List * GetPublicationRelations(Oid pubid, PublicationPartOpt pub_partopt)
Oid get_publication_oid(const char *pubname, bool missing_ok)
char * get_publication_name(Oid pubid, bool missing_ok)
struct PublicationActions PublicationActions
List * GetAllTablesPublications(void)
List * GetAllTablesPublicationRelations(bool pubviaroot)
List * GetPubPartitionOptionRelations(List *result, PublicationPartOpt pub_partopt, Oid relid)
FormData_pg_publication * Form_pg_publication
List * GetAllSchemaPublicationRelations(Oid puboid, PublicationPartOpt pub_partopt)
ObjectAddress publication_add_relation(Oid pubid, PublicationRelInfo *targetrel, bool if_not_exists)
List * GetSchemaPublicationRelations(Oid schemaid, PublicationPartOpt pub_partopt)
struct Publication Publication
bool is_publishable_relation(Relation rel)
PublicationPartOpt
@ PUBLICATION_PART_LEAF
@ PUBLICATION_PART_ROOT
@ PUBLICATION_PART_ALL
unsigned int Oid
Definition: postgres_ext.h:31
Definition: pg_list.h:51
PublicationActions pubactions
Definition: c.h:676