aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorAmit Kapila <akapila@postgresql.org>2025-01-22 15:27:37 +0530
committerAmit Kapila <akapila@postgresql.org>2025-01-22 15:27:37 +0530
commit991974bb48886201948cd8d3f4ea7bce2c6bda4b (patch)
treea42e50c9c720f9f60158c3bafc3293dc0ee5ff88 /src
parent41084409f635453efce03f1114880189b4f6ce4c (diff)
downloadpostgresql-991974bb48886201948cd8d3f4ea7bce2c6bda4b.tar.gz
postgresql-991974bb48886201948cd8d3f4ea7bce2c6bda4b.zip
Fix \dRp+ output when describing publications with a lower server version.
The psql was not careful that the new column "Generated columns" won't be present in the lower version. This was introduced in recent commit 7054186c4e. Author: Vignesh C Reviewed-by: Peter Smith Discussion: https://postgr.es/m/CALDaNm3OcXdY0EzDEKAfaK9gq2B67Mfsgxu93+_249ohyts=0g@mail.gmail.com
Diffstat (limited to 'src')
-rw-r--r--src/bin/psql/describe.c11
1 files changed, 11 insertions, 0 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 2ef99971ac0..8c0ad8439eb 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -6495,12 +6495,23 @@ describePublications(const char *pattern)
if (has_pubtruncate)
appendPQExpBufferStr(&buf,
", pubtruncate");
+ else
+ appendPQExpBufferStr(&buf,
+ ", false AS pubtruncate");
+
if (has_pubgencols)
appendPQExpBufferStr(&buf,
", pubgencols");
+ else
+ appendPQExpBufferStr(&buf,
+ ", false AS pubgencols");
+
if (has_pubviaroot)
appendPQExpBufferStr(&buf,
", pubviaroot");
+ else
+ appendPQExpBufferStr(&buf,
+ ", false AS pubviaroot");
appendPQExpBufferStr(&buf,
"\nFROM pg_catalog.pg_publication\n");