Re: no default hash partition

On 2019-Aug-07, Tom Lane wrote:

> Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> > Actually, it also says this (in the blurb for the PARTITION OF clause):
> 
> >       Creates the table as a <firstterm>partition</firstterm> of the specified
> >       parent table. The table can be created either as a partition for specific
> >       values using <literal>FOR VALUES</literal> or as a default partition
> >       using <literal>DEFAULT</literal>.  This option is not available for
> >       hash-partitioned tables.
> 
> > which I think is sufficient.
> 
> Hm, that's rather confusingly worded IMO.  Is the antecedent of "this
> option" just DEFAULT, or does it mean that you can't use FOR VALUES,
> or perchance it means that you can't use a PARTITION OF clause
> at all?

Uh, you're right, I hadn't noticed that.  Not my text.  I think this can
be fixed easily as in the attached.  There are other options, but I like
this one the best.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services