Re: [HACKERS] New partitioning - some feedback - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] New partitioning - some feedback
Date
Msg-id CA+TgmoZxa-1rDr6YS_LQ_jnbNKG9DacBt5ytE0A_W+3YNCe_Kg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] New partitioning - some feedback  (David Fetter <david@fetter.org>)
Responses Re: [HACKERS] New partitioning - some feedback
List pgsql-hackers
On Mon, Jul 10, 2017 at 5:46 PM, David Fetter <david@fetter.org> wrote:
> With utmost respect, it's less messy than adding '!' to the already
> way too random and mysterious syntax of psql's \ commands.  What
> should '\det!' mean?  What about '\dT!'?

Since \det lists foreign tables, \det! would list foreign tables even
if they are partitions.  Plain \det would show only the ones that are
not partitions.

\dT! wouldn't be meaningful, since \dT lists data types and data types
can't be partitions.  If you're trying to conjure up a rule that every
\d<something> command must accept the same set of modifiers, a quick
look at the output of \? and a little experimentation will quickly
show you that neither S nor + apply to all command types, so I see no
reason why that would need to be true for a new modifier either.

TBH, I think we should just leave this well enough alone.  We're
post-beta2 now, there's no clear consensus on what to do here, and
there will be very little opportunity for users to give us feedback if
we stick a change into an August beta3 before a September final
release.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Pluggable storage
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] hash index on unlogged tables doesn't behave as expected