On Mon, Apr 24, 2017 at 5:10 AM, Rahila Syed <rahilasye...@gmail.com> wrote: > Following can also be considered as it specifies more clearly that the > partition holds default values. > > CREATE TABLE ...PARTITION OF...FOR VALUES DEFAULT;
Yes, that could be done. But I don't think it's correct to say that the partition holds default values. Let's back up and ask what the word "default" means. The relevant definition (according to Google or whoever they stole it from) is: a preselected option adopted by a computer program or other mechanism when no alternative is specified by the user or programmer. So, a default *value* is the value that is used when no alternative is specified by the user or programmer. We have that concept, but it's not what we're talking about here: that's configured by applying the DEFAULT property to a column. Here, we're talking about the default *partition*, or in other words the *partition* that is used when no alternative is specified by the user or programmer. So, that's why I proposed the syntax I did. The partition doesn't contain default values; it is itself a default. -- 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
