Re: table partition and column default

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: table partition and column default
Дата
Msg-id CAHGQGwEobDbrapZ7CDGx8tC3YLvLUVMoO426LGYdrqcFVwiSSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: table partition and column default  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: table partition and column default  (Julien Rouhaud <rjuju123@gmail.com>)
Список pgsql-hackers
On Wed, Dec 25, 2019 at 5:47 PM Amit Langote <amitlangote09@gmail.com> wrote:
>
> On Wed, Dec 25, 2019 at 5:40 PM Fujii Masao <masao.fujii@gmail.com> wrote:
> > On Wed, Dec 25, 2019 at 1:56 PM Amit Langote <amitlangote09@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 for reviewing the patch. Committed!

Regards,

-- 
Fujii Masao



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: unsupportable composite type partition keys
Следующее
От: Fujii Masao
Дата:
Сообщение: table partitioning and access privileges