| From: | "Sven R(dot) Kunze" <srkunze(at)mail(dot)de> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Rahila Syed <rahilasyed90(at)gmail(dot)com>, 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-30 19:27:02 |
| Message-ID: | 1583c349-b3fd-0f8f-7018-53dd240d86b2@mail.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 27.04.2017 22:21, Robert Haas wrote:
> On Thu, Apr 27, 2017 at 3:15 PM, Sven R. Kunze <srkunze(at)mail(dot)de> wrote:
>> 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?
> FALLBACK wouldn't be a good choice because it's not an existing parser
> keyword. We could probably insert AS before DEFAULT and/or PARTITION
> afterwards, but they sort of seem like noise words.
You are right. I just thought it would make this variant more acceptable
as people expressed concerns about understandability of the command.
> SQL seems to have
> been invented by people who didn't have any trouble remembering really
> long command strings, but brevity is not without some merit.
For me, it's exactly the thing I like about SQL. It makes for an easy
learning curve.
Sven
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2017-04-30 21:54:48 | Re: CTE inlining |
| Previous Message | Michael Paquier | 2017-04-30 12:30:08 | Re: Concurrent ALTER SEQUENCE RESTART Regression |