| From: | "Sven R(dot) Kunze" <srkunze(at)mail(dot)de> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com>, Keith Fiske <keith(at)omniti(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>, David Steele <david(at)pgmasters(dot)net>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Adding support for Default partition in partitioning |
| Date: | 2017-04-27 19:15:30 |
| Message-ID: | ad1d93d4-e68b-89c2-e433-e3316635a36e@mail.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 27.04.2017 15:07, Robert Haas wrote:
> On Thu, Apr 27, 2017 at 8:49 AM, Rahila Syed <rahilasyed90(at)gmail(dot)com> wrote:
>> +1 for CREATE TABLE..PARTITION OF...DEFAULT syntax.
>> I think substituting DEFAULT for FOR VALUES is appropriate as
>> both cases are mutually exclusive.
Just to make sound a little rounder:
CREATE TABLE ... PARTITION OF ... AS DEFAULT
CREATE TABLE ... PARTITION OF ... AS FALLBACK
or
CREATE TABLE ... PARTITION OF ... AS DEFAULT PARTITION
CREATE TABLE ... PARTITION OF ... AS FALLBACK PARTITION
Could any of these be feasible?
Sven
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Jelinek | 2017-04-27 19:33:37 | Re: Interval for launching the table sync worker |
| Previous Message | Peter Eisentraut | 2017-04-27 19:06:56 | Re: Logical replication in the same cluster |