Horton

Topup-permissions-test_diff

application/octet-stream

Download
Filename: Topup-permissions-test_diff
Type: application/octet-stream
Part: 0
Message: RE: Added schema level support for publication. 
diff --git a/src/test/regress/expected/publication.out b/src/test/regress/expected/publication.out
index 79ed292c18..971e8fa66c 100644
--- a/src/test/regress/expected/publication.out
+++ b/src/test/regress/expected/publication.out
@@ -342,6 +342,8 @@ GRANT CREATE ON DATABASE regression TO regress_publication_user2;
 SET ROLE regress_publication_user2;
 SET client_min_messages = 'ERROR';
 CREATE PUBLICATION testpub2;  -- ok
+CREATE PUBLICATION testpub3 FOR ALL TABLES IN SCHEMA pub_test;  -- fail
+ERROR:  must be superuser to create FOR ALL TABLES IN SCHEMA publication
 CREATE PUBLICATION testpub3;  -- ok
 RESET client_min_messages;
 ALTER PUBLICATION testpub2 ADD TABLE testpub_tbl1;  -- fail
diff --git a/src/test/regress/sql/publication.sql b/src/test/regress/sql/publication.sql
index 837a9ab910..a0b0406713 100644
--- a/src/test/regress/sql/publication.sql
+++ b/src/test/regress/sql/publication.sql
@@ -188,6 +188,7 @@ GRANT CREATE ON DATABASE regression TO regress_publication_user2;
 SET ROLE regress_publication_user2;
 SET client_min_messages = 'ERROR';
 CREATE PUBLICATION testpub2;  -- ok
+CREATE PUBLICATION testpub3 FOR ALL TABLES IN SCHEMA pub_test;  -- fail
 CREATE PUBLICATION testpub3;  -- ok
 RESET client_min_messages;