On Friday, February 27, 2026, yuanchao zhang <[email protected]> wrote:
> Hi, > I created a domain object named `numeric` using the following statement: > `CREATE DOMAIN numeric AS NUMERIC(12,2) DEFAULT 0 CHECK (VALUE >= 0);` > After executing this SQL, it indicated that the domain was created > successfully. However, when I executed `\dD` in psql, the created domain > could not be displayed. > > The reason is that the name I used is the same as a built-in type (of > course, similar issues exist not only with domains). However, our manual > for the `\dD` command lacks relevant explanations, which can mislead users. > Users might think an object was successfully created, but the `\d` command > doesn't display it, which could make beginners doubt whether the object was > created successfully. I suggest adding necessary explanations to the `\d` > command's manual. > As explained in your bug report the documentation already covers namespaces, types, and the pattern argument to the \d meta commands. Covering all of that within the scope of the specific “\dD” meta command to explain your example case is very unappealing. I honestly don’t see this going anywhere unless you propose specific text and location suggestions for what such a patch should look like. A real patch is even better, but with solid enough ideas someone might volunteer to bundle it all into sgml format. David J.
