Re: Proposal for syntax to support creation of partition tables when creating parent table - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Proposal for syntax to support creation of partition tables when creating parent table
Date
Msg-id 18182.1569426807@sss.pgh.pa.us
Whole thread Raw
In response to Proposal for syntax to support creation of partition tables whencreating parent table  (Muhammad Usama <m.usama@gmail.com>)
Responses Re: Proposal for syntax to support creation of partition tables whencreating parent table
List pgsql-hackers
Muhammad Usama <m.usama@gmail.com> writes:
> I want to propose an extension to CREATE TABLE syntax to allow the creation
> of partition tables along with its parent table using a single statement.

TBH, I think this isn't a particularly good idea.  It seems very
reminiscent of the variant of CREATE SCHEMA that lets you create
a bunch of contained objects along with the schema.  That variant
is a mess to support and AFAIK it's practically unused in the
real world.  (If it were used, we'd get requests to support more
than the small number of object types that the CREATE SCHEMA
grammar currently allows.)

As Fabien noted, there's been some related discussion about this
area, but nobody was advocating a solution of this particular shape.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Proposal for syntax to support creation of partition tables whencreating parent table
Next
From: Fujii Masao
Date:
Subject: Re: PATCH: standby crashed when replay block which truncated instandby but failed to truncate in master node