On Wed, Dec 25, 2019 at 5:40 PM Fujii Masao <masao.fu...@gmail.com> wrote: > On Wed, Dec 25, 2019 at 1:56 PM Amit Langote <amitlangot...@gmail.com> wrote: > > IIRC, there was some discussion about implementing a feature whereby > > partition's default will used for an attribute if it's null even after > > considering the parent table's default, that is, when no default value > > is defined in the parent. The details are at toward the end of this > > thread: > > > > https://www.postgresql.org/message-id/flat/578398af46350effe7111895a4856b87b02e000e.camel%402ndquadrant.com > > Thanks for pointing that thread! > > As you mentioned in that thread, I also think that this current > behavior (maybe restriction) should be documented. > What about adding the note like "a partition's default value is > not applied when inserting a tuple through a partitioned table." > into the document?
Agreed. > Patch attached. Thanks for creating the patch, looks good to me. Thanks, Amit