postgres.git / summary / log / commit / refs

commit    991974bb48886201948cd8d3f4ea7bce2c6bda4b
Author:   Amit Kapila <akapila@postgresql.org>
Date:     Wed Jan 22 09:57:37 2025 +0000
First released in: 18.0

    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


 src/bin/psql/describe.c | 11 +++++++++++
 1 file changed, 11 insertions(+)

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");


[parent: 41084409f635]