| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | "Sven R(dot) Kunze" <srkunze(at)mail(dot)de> |
| 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-27 20:21:05 |
| Message-ID: | CA+TgmoafPTFgxXy-Z-UapH4FPk=SeRd0czK=NXG0tNMjDOjSmQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Apr 27, 2017 at 3:15 PM, Sven R. Kunze <srkunze(at)mail(dot)de> wrote:
> 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?
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. 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.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-04-27 20:24:13 | Re: Declarative partitioning - another take |
| Previous Message | Andrew Dunstan | 2017-04-27 20:19:26 | frogmouth failures |