Re: show schema.collate in explain(verbose on)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "wangsh(dot)fnst(at)fujitsu(dot)com" <wangsh(dot)fnst(at)fujitsu(dot)com>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: show schema.collate in explain(verbose on)
Date: 2022-02-21 17:11:16
Message-ID: 518375.1645463476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"wangsh(dot)fnst(at)fujitsu(dot)com" <wangsh(dot)fnst(at)fujitsu(dot)com> writes:
> Since the schema name of relation/function name will be outputted in
> explain's result when verbose(on) is specified. I plan to output the schema
> name of collation as well as relation/function.

While that's not unreasonable in principle, it seems like it'll just be
useless verbosity in pretty much any actual database. In what scenario
would you have duplicate collation names?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2022-02-21 17:23:06 Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file
Previous Message Tom Lane 2022-02-21 17:05:42 Re: making pg_regress less noisy by removing boilerplate