Horton

Re: Adding support for Default partition in partitioning

Sven R. Kunze <srkunze@mail.de>

View thread View on postgr.es
From: "Sven R. Kunze" <srkunze@mail.de>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Rahila Syed <rahilasyed90@gmail.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, Keith Fiske <keith@omniti.com>, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Rushabh Lathia <rushabh.lathia@gmail.com>, David Steele <david@pgmasters.net>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2017-04-30T19:27:02Z
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@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

Commits

  1. Allow a partitioned table to have a default partition.

  2. Adjust min/max values when changing sequence type

  3. BRIN auto-summarization