Improve default partition - Mailing list pgsql-hackers

From Rafia Sabih
Subject Improve default partition
Date
Msg-id CA+FpmFcZ_yNFy0gmTjk6GHayh3gUYgnEAdLb2kLJYFrdrTVi0Q@mail.gmail.com
Whole thread Raw
Responses Re: Improve default partition  (Dmitry Dolgov <9erthalion6@gmail.com>)
Re: Improve default partition  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Hello all,

I was just playing around with table partitioning and noticed
1. When one inserts into a parent table with no partitions defined
yet, it errors out
2. Similarly, if we try to insert into a parent table a value which is
not covered in any partition and has no default partition defined, it
errors out

This does not sound very convenient. I was thinking of having some
mechanism for such insertions which automatically creates a default
partition and gives a notice for the user to know that it is going to
the default partition. Basically, always having a default partition.
After all default is something that remains there by default, isn't
it?

I will be happy to know your thoughts on this.

-- 
Regards,
Rafia Sabih



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: POC: Cleaning up orphaned files using undo logs
Next
From: Robert Haas
Date:
Subject: Re: POC: Cleaning up orphaned files using undo logs