| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: no default hash partition |
| Date: | 2019-08-07 16:44:13 |
| Message-ID: | 5255.1565196253@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-08-07 16:52:48 | Re: Grouping isolationtester tests in the schedule |
| Previous Message | Alvaro Herrera | 2019-08-07 16:43:50 | Re: Grouping isolationtester tests in the schedule |