Re: pg14 psql broke \d datname.nspname.relname

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Geoghegan <pg(at)bowt(dot)ie>, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg14 psql broke \d datname.nspname.relname
Date: 2021-10-13 16:54:26
Message-ID: 20211013165426.GD27491@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 13, 2021 at 12:46:27PM -0400, Robert Haas wrote:
> On Tue, Oct 12, 2021 at 12:57 PM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> > I would prefer if it errored if the datname didn't match the current database.
> > After all, it would've helped me to avoid making a confusing problem report.
>
> How would you have felt if it had said something like:
>
> error: argument to \d should be of the form
> [schema-name-pattern.]relation-name-pattern
>
> Would that have been better or worse for you than accepting a third
> part of the pattern as a database name if and only if it matched the
> current database name exactly?

I don't normally type \d a.b.c. I think I copied it out of a log message and
pasted it, and didn't even really know or expect it to work without removing
the datname prefix. After it worked, I noticed a short while later when using
the pg14 client that it had stopped working.

It seems unfortunate if names from log messages qualified with datname were now
rejected. Like this one:

| automatic analyze of table "ts.child.cdrs_2021_10_12"...

--
Justin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2021-10-13 17:05:58 Re: pg14 psql broke \d datname.nspname.relname
Previous Message Robert Haas 2021-10-13 16:50:38 Re: dfmgr additional ABI version fields