This commit broke psql \d datname.nspname.relname

commit 2c8726c4b0a496608919d1f78a5abc8c9b6e0868
Author: Robert Haas <rh...@postgresql.org>
Date:   Wed Feb 3 13:19:41 2021 -0500

    Factor pattern-construction logic out of processSQLNamePattern.
...
    patternToSQLRegex is a little more general than what is required
    by processSQLNamePattern. That function is only interested in
    patterns that can have up to 2 parts, a schema and a relation;
    but patternToSQLRegex can limit the maximum number of parts to
    between 1 and 3, so that patterns can look like either
    "database.schema.relation", "schema.relation", or "relation"
    depending on how it's invoked and what the user specifies.

    processSQLNamePattern only passes two buffers, so works exactly
    the same as before, always interpreting the pattern as either
    a "schema.relation" pattern or a "relation" pattern. But,
    future callers can use this function in other ways.

|$ LD_LIBRARY_PATH=tmp_install/usr/local/pgsql/lib/ src/bin/psql/psql -h /tmp 
regression
|psql (15devel)
|Type "help" for help.
|regression=# \d regresion.public.bit_defaults
|Did not find any relation named "regresion.public.bit_defaults".
|regression=# \d public.bit_defaults
|                     Table "public.bit_defaults"
|...

This worked before v14 (even though the commit message says otherwise).

|$ /usr/lib/postgresql/13/bin/psql -h /tmp regression
|psql (13.2 (Debian 13.2-1.pgdg100+1), server 15devel)
|...
|regression=# \d regresion.public.bit_defaults
|                     Table "public.bit_defaults"
|...

-- 
Justin


Reply via email to