postgres.git / summary / log / commit / refs

commit    1f092a309eeecd097938bacc201c779574ced3b6
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Sat Aug 28 16:04:15 2021 +0000

    psql \dX: reference regclass with "pg_catalog." prefix
    
    Déjà vu of commit fc40ba1296a7, for another backslash command.
    Strictly speaking this isn't a bug, but since all references to catalog
    objects are schema-qualified, we might as well be consistent.  The
    omission first appeared in commit ad600bba0422 and replicated in
    a4d75c86bf15; backpatch to 14.
    
    Author: Justin Pryzby <pryzbyj@telsasoft.com>
    Discussion: https://postgr.es/m/20210827193151.GN26465@telsasoft.com


 src/bin/psql/describe.c | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/bin/psql/describe.c b/src/bin/psql/describe.c
index e130a4df10a..30fb17123e4 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -4735,7 +4735,7 @@ listExtendedStats(const char *pattern)
 		appendPQExpBuffer(&buf,
 						  "pg_catalog.format('%%s FROM %%s', \n"
 						  "  pg_get_statisticsobjdef_columns(es.oid), \n"
-						  "  es.stxrelid::regclass) AS \"%s\"",
+						  "  es.stxrelid::pg_catalog.regclass) AS \"%s\"",
 						  gettext_noop("Definition"));
 	else
 		appendPQExpBuffer(&buf,
@@ -4746,7 +4746,7 @@ listExtendedStats(const char *pattern)
 						  "   ON (es.stxrelid = a.attrelid \n"
 						  "   AND a.attnum = s.attnum \n"
 						  "   AND NOT a.attisdropped)), \n"
-						  "es.stxrelid::regclass) AS \"%s\"",
+						  "es.stxrelid::pg_catalog.regclass) AS \"%s\"",
 						  gettext_noop("Definition"));
 
 	appendPQExpBuffer(&buf,


[parent: fc40ba1296a7]