Re: no default hash partition

On 2019-Aug-07, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)2ndquadrant(dot)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