Hi Alvaro, On Wed, Aug 7, 2019 at 7:27 AM Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > > Given the discussion starting at > https://postgr.es/m/cafjfprdbiqjzm8sg9+s0x8re-afhds6mflgguw0wvunlgrv...@mail.gmail.com > we don't have default-partition support with the hash partitioning > scheme. That seems a reasonable outcome, but I think we should have a > comment about it (I had to search the reason for this restriction in the > hash-partitioning patch set).
That hash-partitioned tables can't have default partition is mentioned in the CREATE TABLE page: "If DEFAULT is specified, the table will be created as a default partition of the parent table. The parent can either be a list or range partitioned table. A partition key value not fitting into any other partition of the given parent will be routed to the default partition. There can be only one default partition for a given parent table." > How about the attached? Does anyone see > a reason to make this more verbose, and if so to what? If the outcome of this discussion is that we expand our internal documentation of why there's no default hash partition, then should we also expand the user documentation somehow? Thanks, Amit