From 824c923f0118f80f014a6e45a9b33e477f4b990d Mon Sep 17 00:00:00 2001 From: Vignesh Date: Thu, 16 Jan 2025 12:15:59 +0530 Subject: [PATCH v52 2/5] Fix a small typo in publication name. Fix a small typo to change testpib_ins_trunct to testpub_ins_trunct in publication tests. --- src/test/regress/expected/publication.out | 16 ++++++++-------- src/test/regress/sql/publication.sql | 6 +++--- 2 files changed, 11 insertions(+), 11 deletions(-) diff --git a/src/test/regress/expected/publication.out b/src/test/regress/expected/publication.out index c48f11f293..df8f15d2ff 100644 --- a/src/test/regress/expected/publication.out +++ b/src/test/regress/expected/publication.out @@ -17,7 +17,7 @@ SELECT obj_description(p.oid, 'pg_publication') FROM pg_publication p; (1 row) SET client_min_messages = 'ERROR'; -CREATE PUBLICATION testpib_ins_trunct WITH (publish = insert); +CREATE PUBLICATION testpub_ins_trunct WITH (publish = insert); RESET client_min_messages; ALTER PUBLICATION testpub_default SET (publish = update); -- error cases @@ -39,8 +39,8 @@ ERROR: publish_generated_columns requires a Boolean value List of publications Name | Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root --------------------+--------------------------+------------+---------+---------+---------+-----------+-------------------+---------- - testpib_ins_trunct | regress_publication_user | f | t | f | f | f | f | f testpub_default | regress_publication_user | f | f | t | f | f | f | f + testpub_ins_trunct | regress_publication_user | f | t | f | f | f | f | f (2 rows) ALTER PUBLICATION testpub_default SET (publish = 'insert, update, delete'); @@ -48,8 +48,8 @@ ALTER PUBLICATION testpub_default SET (publish = 'insert, update, delete'); List of publications Name | Owner | All tables | Inserts | Updates | Deletes | Truncates | Generated columns | Via root --------------------+--------------------------+------------+---------+---------+---------+-----------+-------------------+---------- - testpib_ins_trunct | regress_publication_user | f | t | f | f | f | f | f testpub_default | regress_publication_user | f | t | t | t | f | f | f + testpub_ins_trunct | regress_publication_user | f | t | f | f | f | f | f (2 rows) --- adding tables @@ -1183,7 +1183,7 @@ DETAIL: This operation is not supported for views. ALTER PUBLICATION testpub_default ADD TABLE testpub_tbl1; ALTER PUBLICATION testpub_default SET TABLE testpub_tbl1; ALTER PUBLICATION testpub_default ADD TABLE pub_test.testpub_nopk; -ALTER PUBLICATION testpib_ins_trunct ADD TABLE pub_test.testpub_nopk, testpub_tbl1; +ALTER PUBLICATION testpub_ins_trunct ADD TABLE pub_test.testpub_nopk, testpub_tbl1; \d+ pub_test.testpub_nopk Table "pub_test.testpub_nopk" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description @@ -1191,9 +1191,9 @@ ALTER PUBLICATION testpib_ins_trunct ADD TABLE pub_test.testpub_nopk, testpub_tb foo | integer | | | | plain | | bar | integer | | | | plain | | Publications: - "testpib_ins_trunct" "testpub_default" "testpub_fortbl" + "testpub_ins_trunct" \d+ testpub_tbl1 Table "public.testpub_tbl1" @@ -1204,9 +1204,9 @@ Publications: Indexes: "testpub_tbl1_pkey" PRIMARY KEY, btree (id) Publications: - "testpib_ins_trunct" "testpub_default" "testpub_fortbl" + "testpub_ins_trunct" Not-null constraints: "testpub_tbl1_id_not_null" NOT NULL "id" @@ -1232,8 +1232,8 @@ ERROR: relation "testpub_nopk" is not part of the publication Indexes: "testpub_tbl1_pkey" PRIMARY KEY, btree (id) Publications: - "testpib_ins_trunct" "testpub_fortbl" + "testpub_ins_trunct" Not-null constraints: "testpub_tbl1_id_not_null" NOT NULL "id" @@ -1696,7 +1696,7 @@ LINE 1: CREATE PUBLICATION testpub_error FOR pub_test2.tbl1; DETAIL: One of TABLE or TABLES IN SCHEMA must be specified before a standalone table or schema name. DROP VIEW testpub_view; DROP PUBLICATION testpub_default; -DROP PUBLICATION testpib_ins_trunct; +DROP PUBLICATION testpub_ins_trunct; DROP PUBLICATION testpub_fortbl; DROP PUBLICATION testpub1_forschema; DROP PUBLICATION testpub2_forschema; diff --git a/src/test/regress/sql/publication.sql b/src/test/regress/sql/publication.sql index c4c21a95d0..2c7b9d7a29 100644 --- a/src/test/regress/sql/publication.sql +++ b/src/test/regress/sql/publication.sql @@ -15,7 +15,7 @@ COMMENT ON PUBLICATION testpub_default IS 'test publication'; SELECT obj_description(p.oid, 'pg_publication') FROM pg_publication p; SET client_min_messages = 'ERROR'; -CREATE PUBLICATION testpib_ins_trunct WITH (publish = insert); +CREATE PUBLICATION testpub_ins_trunct WITH (publish = insert); RESET client_min_messages; ALTER PUBLICATION testpub_default SET (publish = update); @@ -795,7 +795,7 @@ ALTER PUBLICATION testpub_default ADD TABLE testpub_tbl1; ALTER PUBLICATION testpub_default SET TABLE testpub_tbl1; ALTER PUBLICATION testpub_default ADD TABLE pub_test.testpub_nopk; -ALTER PUBLICATION testpib_ins_trunct ADD TABLE pub_test.testpub_nopk, testpub_tbl1; +ALTER PUBLICATION testpub_ins_trunct ADD TABLE pub_test.testpub_nopk, testpub_tbl1; \d+ pub_test.testpub_nopk \d+ testpub_tbl1 @@ -1074,7 +1074,7 @@ CREATE PUBLICATION testpub_error FOR pub_test2.tbl1; DROP VIEW testpub_view; DROP PUBLICATION testpub_default; -DROP PUBLICATION testpib_ins_trunct; +DROP PUBLICATION testpub_ins_trunct; DROP PUBLICATION testpub_fortbl; DROP PUBLICATION testpub1_forschema; DROP PUBLICATION testpub2_forschema; -- 2.43.0