On Thu, Apr 6, 2017 at 1:17 AM, Rushabh Lathia <rushabh.lat...@gmail.com> wrote: > I like the idea about having DEFAULT partition for the range partition. With > the > way partition is designed it can have holes into range partition. I think > DEFAULT > for the range partition is a good idea, generally when the range having > holes. When > range is serial then of course DEFAULT partition doen't much sense.
Yes, I like that idea, too. I think the DEFAULT partition should be allowed to be created for either range or list partitioning regardless of whether we think there are any holes, but if you create a DEFAULT partition when there are no holes, you just won't be able to put any data into it. It's silly, but it's not worth the code that it would take to try to prevent it. -- 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