Re: no default hash partition - Mailing list pgsql-hackers

From Tom Lane
Subject Re: no default hash partition
Date
Msg-id 5255.1565196253@sss.pgh.pa.us
Whole thread Raw
In response to Re: no default hash partition  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
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?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Grouping isolationtester tests in the schedule
Next
From: Tom Lane
Date:
Subject: Re: Grouping isolationtester tests in the schedule