v1-0001-describe-table-except-publications.patch

application/octet-stream

Filename: v1-0001-describe-table-except-publications.patch
Type: application/octet-stream
Part: 0
Message: Re: EXCEPT TABLE - Case inconsistency for describe \d and \dRp+

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: format-patch
Series: patch v1-0001
Subject: describe table except publications
File+
src/bin/psql/describe.c 1 1
src/test/regress/expected/publication.out 3 3
From d28f4edd28e15c3af682c6bda2c34aa44eaa9c38 Mon Sep 17 00:00:00 2001
From: Peter Smith <peter.b.smith@fujitsu.com>
Date: Mon, 13 Apr 2026 12:12:00 +1000
Subject: [PATCH v1] describe table except publications

---
 src/bin/psql/describe.c                   | 2 +-
 src/test/regress/expected/publication.out | 6 +++---
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 4e8ff00394a..291c493f594 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -3306,7 +3306,7 @@ describeOneTableDetails(const char *schemaname,
 				tuples = PQntuples(result);
 
 			if (tuples > 0)
-				printTableAddFooter(&cont, _("Except Publications:"));
+				printTableAddFooter(&cont, _("Except publications:"));
 
 			/* Might be an empty set - that's ok */
 			for (i = 0; i < tuples; i++)
diff --git a/src/test/regress/expected/publication.out b/src/test/regress/expected/publication.out
index a9059a39138..d028e9be866 100644
--- a/src/test/regress/expected/publication.out
+++ b/src/test/regress/expected/publication.out
@@ -252,7 +252,7 @@ Indexes:
     "testpub_tbl1_pkey" PRIMARY KEY, btree (id)
 Publications:
     "testpub_foralltables"
-Except Publications:
+Except publications:
     "testpub_foralltables_excepttable"
     "testpub_foralltables_excepttable1"
 
@@ -435,7 +435,7 @@ Except tables:
 --------+---------+-----------+----------+---------
  a      | integer |           |          | 
 Partition of: testpub_root FOR VALUES FROM (0) TO (100)
-Except Publications:
+Except publications:
     "testpub8"
 
 \d testpub_root
@@ -444,7 +444,7 @@ Except Publications:
 --------+---------+-----------+----------+---------
  a      | integer |           |          | 
 Partition key: RANGE (a)
-Except Publications:
+Except publications:
     "testpub8"
 Number of partitions: 1 (Use \d+ to list them.)
 
-- 
2.47.3