Re: Proposal for syntax to support creation of partition tables when creating parent table

Hi Ahsan, Usama

Thanks for starting work on this.

On Thu, Sep 26, 2019 at 3:46 AM Ahsan Hadi <ahsan(dot)hadi(at)gmail(dot)com> wrote:
> On Wed, Sep 25, 2019 at 8:53 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> As Fabien noted, there's been some related discussion about this
>> area, but nobody was advocating a solution of this particular shape.
>
> The thread that Usama mentioned in his email is creating auto-partitions just for HASH partitions, this is trying to do similar for all types of partitions.

I agree that this proposal makes life easier for developers familiar
with the partitioning syntax and features of other databases.
However, it adds little functionality over what users can already do,
even though today it takes multiple commands rather than just one.
The problem is that the syntax proposed here is still verbose because
users still have to spell out all the partition bounds by themselves.

The focus of the other thread, as I understand it, is to implement the
functionality to get the same thing done (create many partitions in
one command) in much less verbose manner. Fabien started the
discussion for hash partitioning because the interface for it seems
straightforward -- just specify the number of partitions and that many
partitions would get created without having to actually specify
modulus/remainder for each. Since the underlying functionality
wouldn't be too different for other partitioning methods, we would
only have to come up with a suitable interface.

Thanks,
Amit