summaryrefslogtreecommitdiff
path: root/contrib/test_decoding/sql/rewrite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/test_decoding/sql/rewrite.sql')
-rw-r--r--contrib/test_decoding/sql/rewrite.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/test_decoding/sql/rewrite.sql b/contrib/test_decoding/sql/rewrite.sql
index 4271b82bead..c9503a0da59 100644
--- a/contrib/test_decoding/sql/rewrite.sql
+++ b/contrib/test_decoding/sql/rewrite.sql
@@ -74,6 +74,11 @@ COMMIT;
VACUUM FULL pg_class;
VACUUM FULL pg_class;
+-- reindexing of important relations / indexes
+REINDEX TABLE pg_class;
+REINDEX INDEX pg_class_oid_index;
+REINDEX INDEX pg_class_tblspc_relfilenode_index;
+
INSERT INTO replication_example(somedata, testcolumn1) VALUES (5, 3);
BEGIN;