On Thu, Apr 27, 2017 at 3:15 PM, Sven R. Kunze <srku...@mail.de> wrote: > On 27.04.2017 15:07, Robert Haas wrote: >> On Thu, Apr 27, 2017 at 8:49 AM, Rahila Syed <rahilasye...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers