| 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: | Whole Thread | Raw Message | 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
| 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. |