diff options
Diffstat (limited to 'contrib/test_decoding')
| -rw-r--r-- | contrib/test_decoding/expected/replorigin.out | 10 | ||||
| -rw-r--r-- | contrib/test_decoding/sql/replorigin.sql | 5 |
2 files changed, 15 insertions, 0 deletions
diff --git a/contrib/test_decoding/expected/replorigin.out b/contrib/test_decoding/expected/replorigin.out index 2e9ef7c823b..49ffaeea2da 100644 --- a/contrib/test_decoding/expected/replorigin.out +++ b/contrib/test_decoding/expected/replorigin.out @@ -56,6 +56,16 @@ SELECT pg_replication_origin_drop('regress_test_decoding: temp'); SELECT pg_replication_origin_drop('regress_test_decoding: temp'); ERROR: replication origin "regress_test_decoding: temp" does not exist +-- specifying reserved origin names is not supported +SELECT pg_replication_origin_create('any'); +ERROR: replication origin name "any" is reserved +DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. +SELECT pg_replication_origin_create('none'); +ERROR: replication origin name "none" is reserved +DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. +SELECT pg_replication_origin_create('pg_replication_origin'); +ERROR: replication origin name "pg_replication_origin" is reserved +DETAIL: Origin names "any", "none", and names starting with "pg_" are reserved. -- various failure checks for undefined slots select pg_replication_origin_advance('regress_test_decoding: temp', '0/1'); ERROR: replication origin "regress_test_decoding: temp" does not exist diff --git a/contrib/test_decoding/sql/replorigin.sql b/contrib/test_decoding/sql/replorigin.sql index 2e28a487773..db06541f565 100644 --- a/contrib/test_decoding/sql/replorigin.sql +++ b/contrib/test_decoding/sql/replorigin.sql @@ -31,6 +31,11 @@ SELECT pg_replication_origin_create('regress_test_decoding: temp'); SELECT pg_replication_origin_drop('regress_test_decoding: temp'); SELECT pg_replication_origin_drop('regress_test_decoding: temp'); +-- specifying reserved origin names is not supported +SELECT pg_replication_origin_create('any'); +SELECT pg_replication_origin_create('none'); +SELECT pg_replication_origin_create('pg_replication_origin'); + -- various failure checks for undefined slots select pg_replication_origin_advance('regress_test_decoding: temp', '0/1'); select pg_replication_origin_session_setup('regress_test_decoding: temp'); |