Re: [HACKERS] Adding support for Default partition in partitioning

On Thu, Apr 27, 2017 at 3:15 PM, Sven R. Kunze <srkunze@mail.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