[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] Adding support for Default partition in partitioning
From:       "Sven R. Kunze" <srkunze () mail ! de>
Date:       2017-04-30 19:27:02
Message-ID: 1583c349-b3fd-0f8f-7018-53dd240d86b2 () mail ! de
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 27.04.2017 22:21, Robert Haas wrote:<br>
    </div>
    <blockquote
cite="mid:CA+TgmoafPTFgxXy-Z-UapH4FPk=SeRd0czK=NXG0tNMjDOjSmQ@mail.gmail.com"
      type="cite">
      <pre wrap="">On Thu, Apr 27, 2017 at 3:15 PM, Sven R. Kunze <a \
class="moz-txt-link-rfc2396E" \
href="mailto:srkunze@mail.de">&lt;srkunze@mail.de&gt;</a> wrote: </pre>
      <blockquote type="cite">
        <pre wrap="">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?
</pre>
      </blockquote>
      <pre wrap="">
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.</pre>
    </blockquote>
    <br>
    You are right. I just thought it would make this variant more
    acceptable as people expressed concerns about understandability of
    the command.<br>
    <br>
    <blockquote
cite="mid:CA+TgmoafPTFgxXy-Z-UapH4FPk=SeRd0czK=NXG0tNMjDOjSmQ@mail.gmail.com"
      type="cite">
      <pre wrap="">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.
</pre>
    </blockquote>
    <br>
    For me, it's exactly the thing I like about SQL. It makes for an
    easy learning curve.<br>
    <br>
    <br>
    Sven<br>
  </body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic