aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2022-04-15 18:31:01 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2022-04-15 18:31:01 -0400
commit7129a9791eafdd825eae0187b7dd7b99ed48fdc7 (patch)
treea8348782b83712a4b742d189408d1b1c56a8bc4d
parent6fea65508a1aa6a1caa5f3e7b4d27bcccb0740d8 (diff)
downloadpostgresql-7129a9791eafdd825eae0187b7dd7b99ed48fdc7.tar.gz
postgresql-7129a9791eafdd825eae0187b7dd7b99ed48fdc7.zip
psql: fix \l display for pre-v15 databases.
With a pre-v15 server, show NULL for the "ICU Locale" column, matching what you see in v15 when the database locale isn't ICU. The previous coding incorrectly repeated datcollate here. (There's an unfinished discussion about whether to consolidate these columns in \l output, but in any case we'd want this fix for \l+ output.) Euler Taveira, per report from Christoph Berg Discussion: https://postgr.es/m/YlmIFCqu+TZSW4rB@msg.df7cb.de
-rw-r--r--src/bin/psql/describe.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index 839f1add900..583817b0cc6 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -904,7 +904,7 @@ listAllDbs(const char *pattern, bool verbose)
gettext_noop("Locale Provider"));
else
appendPQExpBuffer(&buf,
- " d.datcollate as \"%s\",\n"
+ " NULL as \"%s\",\n"
" 'libc' AS \"%s\",\n",
gettext_noop("ICU Locale"),
gettext_noop("Locale Provider"));