pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feed\dP and \dX use ::regclass without "pg_catalog."
10+ messages / 5 participants
[nested] [flat]
* \dP and \dX use ::regclass without "pg_catalog."
@ 2021-08-27 19:31 Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 1 reply; 10+ messages in thread
From: Justin Pryzby @ 2021-08-27 19:31 UTC (permalink / raw)
To: pgsql-hackers@lists.postgresql.org; +Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>; Tomas Vondra <tomas.vondra@enterprisedb.com>; Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
I noticed that for \dP+ since 1c5d9270e, regclass is written without
"pg_catalog." (Alvaro and I failed to notice it in 421a2c483, too).
+ if (showNested || pattern)
+ appendPQExpBuffer(&buf,
+ ",\n c3.oid::regclass as \"%s\"",
+ gettext_noop("Parent name"));
+
+ if (showIndexes)
+ appendPQExpBuffer(&buf,
+ ",\n c2.oid::regclass as \"%s\"",
+ gettext_noop("On table"));
\dX is new in v14, and introduced the same issue in ad600bba0 (and modifies it
but not fixed in a4d75c86).
I searched for issues like this, which finds all 4 errors with 1 false positive
in psql/describe.c
|time grep -wF "$(grep -oE 'pg_catalog\.[_[:alpha:]]+' src/bin/psql/describe.c |sed -r 's/^pg_catalog\.//; /^(char|oid|text|trigger)$/d' )" src/bin/psql/describe.c |grep -Ev 'pg_catalog\.|^ *[/ ]\*'
|#include "catalog/pg_am.h"
| ",\n inh.inhparent::regclass as \"%s\"",
| ",\n c2.oid::regclass as \"%s\"",
| " es.stxrelid::regclass) AS \"%s\"",
| "es.stxrelid::regclass) AS \"%s\"",
Tom informs me that this is not considered to be interesting as a security patch.
--
Justin
Attachments:
[text/x-diff] 0001-psql-dX-reference-regclass-with-pg_catalog.-prefix.patch (1.3K, ../../20210827193151.GN26465@telsasoft.com/2-0001-psql-dX-reference-regclass-with-pg_catalog.-prefix.patch)
download | inline diff:
From 70eb6d65084104fa54965a349474cda8db6ed90d Mon Sep 17 00:00:00 2001
From: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Fri, 27 Aug 2021 13:52:39 -0500
Subject: [PATCH 1/2] psql \dX: reference regclass with "pg_catalog." prefix
Should backpatch to v14
See similar issue fixed at 1d21ba8a9b8cb784f927a2c9c5818f8ff6779c0b.
---
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 8333558bda..772d881c2f 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,
--
2.17.0
[text/x-diff] 0002-psql-dP-reference-regclass-with-pg_catalog.-prefix.patch (1019B, ../../20210827193151.GN26465@telsasoft.com/3-0002-psql-dP-reference-regclass-with-pg_catalog.-prefix.patch)
download | inline diff:
From 9e243f51a095ec2ca5949d711483be2546e46d0e Mon Sep 17 00:00:00 2001
From: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Fri, 27 Aug 2021 13:52:15 -0500
Subject: [PATCH 2/2] psql \dP: reference regclass with "pg_catalog." prefix
Should backpatch to v12
---
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 772d881c2f..30fb17123e 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -4275,12 +4275,12 @@ listPartitionedTables(const char *reltypes, const char *pattern, bool verbose)
if (showNested || pattern)
appendPQExpBuffer(&buf,
- ",\n inh.inhparent::regclass as \"%s\"",
+ ",\n inh.inhparent::pg_catalog.regclass as \"%s\"",
gettext_noop("Parent name"));
if (showIndexes)
appendPQExpBuffer(&buf,
- ",\n c2.oid::regclass as \"%s\"",
+ ",\n c2.oid::pg_catalog.regclass as \"%s\"",
gettext_noop("Table"));
if (verbose)
--
2.17.0
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2021-08-28 12:57 Álvaro Herrera <alvherre@alvh.no-ip.org>
parent: Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 0 replies; 10+ messages in thread
From: Álvaro Herrera @ 2021-08-28 12:57 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; +Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
On 2021-Aug-27, Justin Pryzby wrote:
> I noticed that for \dP+ since 1c5d9270e, regclass is written without
> "pg_catalog." (Alvaro and I failed to notice it in 421a2c483, too).
Oops, will fix shortly.
--
Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-07 02:22 Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 1 reply; 10+ messages in thread
From: Justin Pryzby @ 2022-01-07 02:22 UTC (permalink / raw)
To: Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; pgsql-hackers; Alvaro Herrera <alvherre@2ndquadrant.com>
https://www.postgresql.org/message-id/flat/7ad8cd13-db5b-5cf6-8561-dccad1a934cb%40nttcom.co.jp
https://www.postgresql.org/message-id/flat/20210827193151.GN26465%40telsasoft.com
On Sat, Aug 28, 2021 at 08:57:32AM -0400, Álvaro Herrera wrote:
> On 2021-Aug-27, Justin Pryzby wrote:
> > I noticed that for \dP+ since 1c5d9270e, regclass is written without
> > "pg_catalog." (Alvaro and I failed to notice it in 421a2c483, too).
>
> Oops, will fix shortly.
On Tue, Sep 28, 2021 at 04:25:11PM +0200, Magnus Hagander wrote:
> On Mon, Sep 27, 2021 at 2:14 AM Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp> wrote:
> > I found other functions that we should add "pg_catalog" prefix in
> > describe.c. This fix is similar to the following commit.
>
> Yup, that's correct. Applied and backpatched to 14 (but it won't be in the
> 14.0 release).
Those two issues were fixed in 1f092a309 and 07f8a9e784.
But, we missed two casts to ::text which don't use pg_catalog.
Evidently the cast is to allow stable sorting.
I improved on my previous hueristic to look for these ; this finds the two
missing schema qualifiers:
> time grep "$(sed -r "/.*pg_catalog\\.([_[:alpha:]]+).*/! d; s//\\1/; /^(char|oid)$/d; s/.*/[^. ']\\\\<&\\\\>/" src/bin/psql/describe.c |sort -u)" src/bin/psql/describe.c
While looking at that, I wondered why describeOneTableDetails lists stats
objects in order of OID ? Dating back to 7b504eb28, and, before that,
554A73A6.2060603@2ndquadrant.com. It should probably order by nsp, stxname.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-07 09:30 Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
parent: Justin Pryzby <pryzby@telsasoft.com>
0 siblings, 1 reply; 10+ messages in thread
From: Tatsuro Yamada @ 2022-01-07 09:30 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; +Cc: pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers; Alvaro Herrera <alvherre@2ndquadrant.com>
Hi Justin,
On 2022/01/07 11:22, Justin Pryzby wrote:
> But, we missed two casts to ::text which don't use pg_catalog.
> Evidently the cast is to allow stable sorting.
Ah, you are right.
We should prefix them with pg_catalog as well.
Are you planning to make a patch?
If not, I'll make a patch later since that's where \dX is.
Regards,
Tatsuro Yamada
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-07 11:08 Michael Paquier <michael@paquier.xyz>
parent: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
0 siblings, 1 reply; 10+ messages in thread
From: Michael Paquier @ 2022-01-07 11:08 UTC (permalink / raw)
To: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; +Cc: Justin Pryzby <pryzby@telsasoft.com>; Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers; Alvaro Herrera <alvherre@2ndquadrant.com>
On Fri, Jan 07, 2022 at 06:30:30PM +0900, Tatsuro Yamada wrote:
> We should prefix them with pg_catalog as well.
> Are you planning to make a patch?
> If not, I'll make a patch later since that's where \dX is.
If any of you can make a patch, that would be great. Thanks!
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../YdgfSW%2FfSjDC%2F742@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-07 21:56 Justin Pryzby <pryzby@telsasoft.com>
parent: Michael Paquier <michael@paquier.xyz>
0 siblings, 2 replies; 10+ messages in thread
From: Justin Pryzby @ 2022-01-07 21:56 UTC (permalink / raw)
To: Michael Paquier <michael@paquier.xyz>; +Cc: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@2ndquadrant.com>
On Fri, Jan 07, 2022 at 08:08:57PM +0900, Michael Paquier wrote:
> On Fri, Jan 07, 2022 at 06:30:30PM +0900, Tatsuro Yamada wrote:
> > We should prefix them with pg_catalog as well.
> > Are you planning to make a patch?
> > If not, I'll make a patch later since that's where \dX is.
>
> If any of you can make a patch, that would be great. Thanks!
I'd propose these.
Attachments:
[text/x-diff] 0001-psql-qualify-text-with-pg_catalog.patch (1.2K, ../../20220107215620.GH14051@telsasoft.com/2-0001-psql-qualify-text-with-pg_catalog.patch)
download | inline diff:
From d1e337daf81faa9a0a8c33a26091cbae396df7bb Mon Sep 17 00:00:00 2001
From: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Thu, 6 Jan 2022 20:23:52 -0600
Subject: [PATCH 1/3] psql: qualify ::text with pg_catalog
backpatch to v14
---
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 7cbf5f7b105..b3fbff1a0c3 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -4392,7 +4392,7 @@ listExtendedStats(const char *pattern)
initPQExpBuffer(&buf);
printfPQExpBuffer(&buf,
"SELECT \n"
- "es.stxnamespace::pg_catalog.regnamespace::text AS \"%s\", \n"
+ "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS \"%s\", \n"
"es.stxname AS \"%s\", \n",
gettext_noop("Schema"),
gettext_noop("Name"));
@@ -4439,7 +4439,7 @@ listExtendedStats(const char *pattern)
processSQLNamePattern(pset.db, &buf, pattern,
false, false,
- "es.stxnamespace::pg_catalog.regnamespace::text", "es.stxname",
+ "es.stxnamespace::pg_catalog.regnamespace::pg_catalog.text", "es.stxname",
NULL, "pg_catalog.pg_statistics_obj_is_visible(es.oid)");
appendPQExpBufferStr(&buf, "ORDER BY 1, 2;");
--
2.17.1
[text/x-diff] 0002-psql-order-a-relation-s-extended-statistics-by-name.patch (1.2K, ../../20220107215620.GH14051@telsasoft.com/3-0002-psql-order-a-relation-s-extended-statistics-by-name.patch)
download | inline diff:
From 5033095abb3631bf01e4213752d5a4d3a24896fa Mon Sep 17 00:00:00 2001
From: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Thu, 6 Jan 2022 20:25:07 -0600
Subject: [PATCH 2/3] psql: order a relation's extended statistics by name..
like \dX
not by OID
v15 only?
---
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 b3fbff1a0c3..daf06bbcc81 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -2608,7 +2608,7 @@ describeOneTableDetails(const char *schemaname,
printfPQExpBuffer(&buf,
"SELECT oid, "
"stxrelid::pg_catalog.regclass, "
- "stxnamespace::pg_catalog.regnamespace AS nsp, "
+ "stxnamespace::pg_catalog.regnamespace::pg_catalog.text AS nsp, "
"stxname,\n"
"pg_catalog.pg_get_statisticsobjdef_columns(oid) AS columns,\n"
" 'd' = any(stxkind) AS ndist_enabled,\n"
@@ -2617,7 +2617,7 @@ describeOneTableDetails(const char *schemaname,
"stxstattarget\n"
"FROM pg_catalog.pg_statistic_ext stat\n"
"WHERE stxrelid = '%s'\n"
- "ORDER BY 1;",
+ "ORDER BY nsp, stxname;",
oid);
result = PSQLexec(buf.data);
--
2.17.1
[text/x-diff] 0003-Remove-unused-table-alias.patch (1.2K, ../../20220107215620.GH14051@telsasoft.com/4-0003-Remove-unused-table-alias.patch)
download | inline diff:
From 020f425c7ed67183275d64f19c34f69d63b8ddc6 Mon Sep 17 00:00:00 2001
From: Justin Pryzby <pryzbyj@telsasoft.com>
Date: Fri, 7 Jan 2022 15:48:46 -0600
Subject: [PATCH 3/3] Remove unused table alias
---
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 daf06bbcc81..c62d3bd4f8a 100644
--- a/src/bin/psql/describe.c
+++ b/src/bin/psql/describe.c
@@ -2615,7 +2615,7 @@ describeOneTableDetails(const char *schemaname,
" 'f' = any(stxkind) AS deps_enabled,\n"
" 'm' = any(stxkind) AS mcv_enabled,\n"
"stxstattarget\n"
- "FROM pg_catalog.pg_statistic_ext stat\n"
+ "FROM pg_catalog.pg_statistic_ext\n"
"WHERE stxrelid = '%s'\n"
"ORDER BY nsp, stxname;",
oid);
@@ -2719,7 +2719,7 @@ describeOneTableDetails(const char *schemaname,
appendPQExpBufferStr(&buf, " stxstattarget\n");
else
appendPQExpBufferStr(&buf, " -1 AS stxstattarget\n");
- appendPQExpBuffer(&buf, "FROM pg_catalog.pg_statistic_ext stat\n"
+ appendPQExpBuffer(&buf, "FROM pg_catalog.pg_statistic_ext\n"
"WHERE stxrelid = '%s'\n"
"ORDER BY 1;",
oid);
--
2.17.1
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-08 07:47 Michael Paquier <michael@paquier.xyz>
parent: Justin Pryzby <pryzby@telsasoft.com>
1 sibling, 1 reply; 10+ messages in thread
From: Michael Paquier @ 2022-01-08 07:47 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; +Cc: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@2ndquadrant.com>
On Fri, Jan 07, 2022 at 03:56:20PM -0600, Justin Pryzby wrote:
> I'd propose these.
Applied and backpatched down to 14. One of the aliases is present in
13~, but I have let that alone. The detection regex posted upthread
is kind of cool.
--
Michael
Attachments:
[application/pgp-signature] signature.asc (832B, ../../YdlBqKDsHSbSsQ1j@paquier.xyz/2-signature.asc)
download
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-08 19:50 Álvaro Herrera <alvherre@alvh.no-ip.org>
parent: Michael Paquier <michael@paquier.xyz>
0 siblings, 1 reply; 10+ messages in thread
From: Álvaro Herrera @ 2022-01-08 19:50 UTC (permalink / raw)
To: Michael Paquier <michael@paquier.xyz>; +Cc: Justin Pryzby <pryzby@telsasoft.com>; Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers
On 2022-Jan-08, Michael Paquier wrote:
> The detection regex posted upthread is kind of cool.
Yes, but it's not bulletproof -- it only detects uses of some
unqualified object name that is also used with qualification. Here it
detected "text" unqualified, but only because we already had
pg_catalog.text elsewhere. As an exercise, if you revert this commit
and change one of those "text" to "int", it's not detected as a problem.
My point is that it's good to have it, but it would be much better to
have something bulletproof, which we could use in an automated check
somewhere (next to stuff like perlcritic, perhaps). I don't know what,
though.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Cuando no hay humildad las personas se degradan" (A. Christie)
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-08 20:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Álvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 0 replies; 10+ messages in thread
From: Tom Lane @ 2022-01-08 20:03 UTC (permalink / raw)
To: Álvaro Herrera <alvherre@alvh.no-ip.org>; +Cc: Michael Paquier <michael@paquier.xyz>; Justin Pryzby <pryzby@telsasoft.com>; Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers
=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org> writes:
> My point is that it's good to have it, but it would be much better to
> have something bulletproof, which we could use in an automated check
> somewhere (next to stuff like perlcritic, perhaps). I don't know what,
> though.
Meh ... this is mostly cosmetic these days, so I can't get excited
about putting a lot of work into it. We disclaimed search path
bulletproofness for all these queries a long time ago.
I don't object to fixing it in the name of consistency, but that's
not a reason to invest large effort.
regards, tom lane
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: \dP and \dX use ::regclass without "pg_catalog."
@ 2022-01-11 01:57 Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
parent: Justin Pryzby <pryzby@telsasoft.com>
1 sibling, 0 replies; 10+ messages in thread
From: Tatsuro Yamada @ 2022-01-11 01:57 UTC (permalink / raw)
To: Justin Pryzby <pryzby@telsasoft.com>; Michael Paquier <michael@paquier.xyz>; +Cc: Álvaro Herrera <alvherre@alvh.no-ip.org>; Magnus Hagander <magnus@hagander.net>; pgsql-hackers@lists.postgresql.org, Tomas Vondra <tomas.vondra@enterprisedb.com>; pgsql-hackers@postgresql.org, Alvaro Herrera <alvherre@2ndquadrant.com>
Hi justin,
On 2022/01/08 6:56, Justin Pryzby wrote:
> On Fri, Jan 07, 2022 at 08:08:57PM +0900, Michael Paquier wrote:
>> On Fri, Jan 07, 2022 at 06:30:30PM +0900, Tatsuro Yamada wrote:
>>> We should prefix them with pg_catalog as well.
>>> Are you planning to make a patch?
>>> If not, I'll make a patch later since that's where \dX is.
>>
>> If any of you can make a patch, that would be great. Thanks!
>
> I'd propose these.
Thanks!
Regards,
Tatsuro Yamada
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2022-01-11 01:57 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-27 19:31 \dP and \dX use ::regclass without "pg_catalog." Justin Pryzby <pryzby@telsasoft.com>
2021-08-28 12:57 ` Álvaro Herrera <alvherre@alvh.no-ip.org>
2022-01-07 02:22 Re: \dP and \dX use ::regclass without "pg_catalog." Justin Pryzby <pryzby@telsasoft.com>
2022-01-07 09:30 ` Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
2022-01-07 11:08 ` Michael Paquier <michael@paquier.xyz>
2022-01-07 21:56 ` Justin Pryzby <pryzby@telsasoft.com>
2022-01-08 07:47 ` Michael Paquier <michael@paquier.xyz>
2022-01-08 19:50 ` Álvaro Herrera <alvherre@alvh.no-ip.org>
2022-01-08 20:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-01-11 01:57 ` Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox