Skip to content

Commit 991974b

Browse files
author
Amit Kapila
committed
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 7054186. Author: Vignesh C Reviewed-by: Peter Smith Discussion: https://postgr.es/m/CALDaNm3OcXdY0EzDEKAfaK9gq2B67Mfsgxu93+_249ohyts=0g@mail.gmail.com
1 parent 4108440 commit 991974b

File tree

1 file changed

+11
-0
lines changed

1 file changed

+11
-0
lines changed

src/bin/psql/describe.c

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6495,12 +6495,23 @@ describePublications(const char *pattern)
64956495
if (has_pubtruncate)
64966496
appendPQExpBufferStr(&buf,
64976497
", pubtruncate");
6498+
else
6499+
appendPQExpBufferStr(&buf,
6500+
", false AS pubtruncate");
6501+
64986502
if (has_pubgencols)
64996503
appendPQExpBufferStr(&buf,
65006504
", pubgencols");
6505+
else
6506+
appendPQExpBufferStr(&buf,
6507+
", false AS pubgencols");
6508+
65016509
if (has_pubviaroot)
65026510
appendPQExpBufferStr(&buf,
65036511
", pubviaroot");
6512+
else
6513+
appendPQExpBufferStr(&buf,
6514+
", false AS pubviaroot");
65046515

65056516
appendPQExpBufferStr(&buf,
65066517
"\nFROM pg_catalog.pg_publication\n");

0 commit comments

Comments
 (0)