Re: hash partitioning based on v10Beta2

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "yangjie(at)highgo(dot)com" <yangjie(at)highgo(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: hash partitioning based on v10Beta2
Date: 2017-08-28 14:26:33
Message-ID: CA+TgmoYRW6YuzpoLg7-BQLE23dt-yg-S7BfgLfHXyTf4tc=NRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Aug 26, 2017 at 12:40 AM, yangjie(at)highgo(dot)com <yangjie(at)highgo(dot)com> wrote:
> A partition table can be create as bellow:
>
> CREATE TABLE h1 PARTITION OF h;
> CREATE TABLE h2 PARTITION OF h;
> CREATE TABLE h3 PARTITION OF h;

This syntax is very problematic for reasons that have been discussed
on the existing hash partitioning thread. Fortunately, a solution has
already been implemented... you're the third person to try to write a
patch for this feature.

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Murphy 2017-08-28 14:31:16 Re: 1 test fails in make installcheck-world - database "regress_ecpg_user2" does not exist
Previous Message Robert Haas 2017-08-28 14:24:14 Re: [COMMITTERS] pgsql: pg_rewind: Fix some problems when copying files >2GB.