MIME-Version: 1.0
References: <19417-401f33ed14f3d4d5@postgresql.org>
In-Reply-To: <19417-401f33ed14f3d4d5@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 26 Feb 2026 09:12:41 -0700
Message-ID: <CAKFQuwb0SLTxUMUxgE=xegwzwAGXqYJ61McLexszb-vTa4y=Mg@mail.gmail.com>
Subject: Re: BUG #19417: '\dD' fails to list user-defined domains that shadow
 built-in type names (e.g., 'numeric')
To: zhangyc0706@gmail.com, pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000001e50064bbc66db"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwb0SLTxUMUxgE%3DxegwzwAGXqYJ61McLexszb-vTa4y%3DMg%40mail.gmail.com>
Precedence: bulk

--000000000000001e50064bbc66db
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Feb 26, 2026 at 8:43=E2=80=AFAM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19417
> Logged by:          yuanchao zhang
> Email address:      zhangyc0706@gmail.com
> PostgreSQL version: 18.2
> Operating system:   windows 10
> Description:
>
> Because I checked the documentation regarding the use of '\dD', and there
> was no explanation for this special case.
>
>
Because it is not a special case of \dD specifically but a behavior of how
all the \d meta-commands function.  This behavior is documented under
Patterns (here, the absence of specifying any pattern):

''""
Whenever the pattern parameter is omitted completely, the \d commands
display all objects that are visible in the current schema search path =E2=
=80=94
this is equivalent to using * as the pattern. (An object is said to be
visible if its containing schema is in the search path and no object of the
same kind and name appears earlier in the search path. This is equivalent
to the statement that the object can be referenced by name without explicit
schema qualification.)
"""

Your new domain is not visible since the plain type numeric in pg_catalog
is implicitly first in the default search_path.

https://www.postgresql.org/docs/current/app-psql.html
https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-SEAR=
CH-PATH

David J.

--000000000000001e50064bbc66db
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Thu, Feb 26, 2026 at 8:43=E2=80=AFAM PG Bug reporting f=
orm &lt;<a href=3D"mailto:noreply@postgresql.org">noreply@postgresql.org</a=
>&gt; wrote:</span></div></div><div class=3D"gmail_quote gmail_quote_contai=
ner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">The following bug ha=
s been logged on the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19417<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 yuanchao zhang<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:zhangyc0706@gmail.com"=
 target=3D"_blank">zhangyc0706@gmail.com</a><br>
PostgreSQL version: 18.2<br>
Operating system:=C2=A0 =C2=A0windows 10<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br><br>
Because I checked the documentation regarding the use of &#39;\dD&#39;, and=
 there<br>
was no explanation for this special case.<br><br></blockquote><div><br></di=
v><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-se=
rif">Because it is not a special case of \dD specifically but a behavior of=
 how all the \d meta-commands function.=C2=A0 This behavior is documented u=
nder Patterns (here, the absence of specifying any pattern):</div><div clas=
s=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></=
div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-=
serif">&#39;&#39;&quot;&quot;</div><div class=3D"gmail_default" style=3D"fo=
nt-family:arial,helvetica,sans-serif">Whenever the pattern parameter is omi=
tted completely, the \d commands display all objects that are visible in th=
e current schema search path =E2=80=94 this is equivalent to using * as the=
 pattern. (An object is said to be visible if its containing schema is in t=
he search path and no object of the same kind and name appears earlier in t=
he search path. This is equivalent to the statement that the object can be =
referenced by name without explicit schema qualification.)</div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">&quot;&=
quot;&quot;</div><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-fa=
mily:arial,helvetica,sans-serif">Your new domain is not visible since the p=
lain type numeric in pg_catalog is implicitly first in the default search_p=
ath.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica=
,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-family:ar=
ial,helvetica,sans-serif"><a href=3D"https://www.postgresql.org/docs/curren=
t/app-psql.html">https://www.postgresql.org/docs/current/app-psql.html</a><=
/div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans=
-serif"><a href=3D"https://www.postgresql.org/docs/current/runtime-config-c=
lient.html#GUC-SEARCH-PATH">https://www.postgresql.org/docs/current/runtime=
-config-client.html#GUC-SEARCH-PATH</a></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f"><br></div></div></div>

--000000000000001e50064bbc66db--