Re: table partition and column default

2020-02-04 Thread Fujii Masao
On 2020/02/04 13:56, Amit Langote wrote: On Thu, Dec 26, 2019 at 6:21 PM Julien Rouhaud wrote: On Thu, Dec 26, 2019 at 7:12 AM Fujii Masao wrote: Thanks for reviewing the patch. Committed! I saw that you only pushed it on master, shouldn't we backpatch it down to pg10 as this is the decl

Re: table partition and column default

2020-02-03 Thread Amit Langote
On Thu, Dec 26, 2019 at 6:21 PM Julien Rouhaud wrote: > On Thu, Dec 26, 2019 at 7:12 AM Fujii Masao wrote: > > Thanks for reviewing the patch. Committed! > > I saw that you only pushed it on master, shouldn't we backpatch it > down to pg10 as this is the declarative partitioning behavior since >

Re: table partition and column default

2019-12-26 Thread Julien Rouhaud
Fuji-san, On Thu, Dec 26, 2019 at 7:12 AM Fujii Masao wrote: > > On Wed, Dec 25, 2019 at 5:47 PM Amit Langote wrote: > > > > On Wed, Dec 25, 2019 at 5:40 PM Fujii Masao wrote: > > > On Wed, Dec 25, 2019 at 1:56 PM Amit Langote > > > wrote: > > > > IIRC, there was some discussion about impleme

Re: table partition and column default

2019-12-25 Thread Fujii Masao
On Wed, Dec 25, 2019 at 5:47 PM Amit Langote wrote: > > On Wed, Dec 25, 2019 at 5:40 PM Fujii Masao wrote: > > On Wed, Dec 25, 2019 at 1:56 PM Amit Langote > > wrote: > > > IIRC, there was some discussion about implementing a feature whereby > > > partition's default will used for an attribute

Re: table partition and column default

2019-12-25 Thread Amit Langote
On Wed, Dec 25, 2019 at 5:40 PM Fujii Masao wrote: > On Wed, Dec 25, 2019 at 1:56 PM Amit Langote 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,

Re: table partition and column default

2019-12-25 Thread Fujii Masao
On Wed, Dec 25, 2019 at 1:56 PM Amit Langote wrote: > > Fujii-san, > > On Wed, Dec 25, 2019 at 12:19 PM Fujii Masao wrote: > > > > Hi, > > > > As the document explains, column defaults can be specified separately for > > each partition. But I found that INSERT via the partitioned table ignores >

Re: table partition and column default

2019-12-24 Thread Amit Langote
Fujii-san, On Wed, Dec 25, 2019 at 12:19 PM Fujii Masao wrote: > > Hi, > > As the document explains, column defaults can be specified separately for > each partition. But I found that INSERT via the partitioned table ignores > that default. Is this expected behavior or bug? > > CREATE TABLE test

table partition and column default

2019-12-24 Thread Fujii Masao
Hi, As the document explains, column defaults can be specified separately for each partition. But I found that INSERT via the partitioned table ignores that default. Is this expected behavior or bug? CREATE TABLE test (i INT, j INT) PARTITION BY RANGE (i); CREATE TABLE test1 PARTITION OF test (j