Hi, I have fixed the issue related to default partition constraints not getting updated after detaching a partition.
PFA. Regards, Jeevan Ladhe On Tue, May 30, 2017 at 1:08 PM, Jeevan Ladhe <jeevan.la...@enterprisedb.com > wrote: > Hi, > > I have rebased the patch on the latest commit. > PFA. > > There exists one issue reported by Rajkumar[1] off-line as following, where > describing the default partition after deleting null partition, does not > show > updated constraints. I am working on fixing this issue. > > create table t1 (c1 int) partition by list (c1); > create table t11 partition of t1 for values in (1,2); > create table t12 partition of t1 default; > create table t13 partition of t1 for values in (10,11); > create table t14 partition of t1 for values in (null); > > postgres=# \d+ t12 > Table "public.t12" > Column | Type | Collation | Nullable | Default | Storage | Stats > target | Description > --------+---------+-----------+----------+---------+-------- > -+--------------+------------- > c1 | integer | | | | plain | > | > Partition of: t1 DEFAULT > Partition constraint: ((c1 IS NOT NULL) AND (c1 <> ALL (ARRAY[1, 2, 10, > 11]))) > > postgres=# alter table t1 detach partition t14; > ALTER TABLE > postgres=# \d+ t12 > Table "public.t12" > Column | Type | Collation | Nullable | Default | Storage | Stats > target | Description > --------+---------+-----------+----------+---------+-------- > -+--------------+------------- > c1 | integer | | | | plain | > | > Partition of: t1 DEFAULT > Partition constraint: ((c1 IS NOT NULL) AND (c1 <> ALL (ARRAY[1, 2, 10, > 11]))) > > postgres=# insert into t1 values(null); > INSERT 0 1 > > Note that the parent correctly allows the nulls to be inserted. > > [1] rajkumar.raghuwan...@enterprisedb.com > > Regards, > Jeevan Ladhe > > On Tue, May 30, 2017 at 10:59 AM, Beena Emerson <memissemer...@gmail.com> > wrote: > >> On Mon, May 29, 2017 at 9:33 PM, Jeevan Ladhe >> <jeevan.la...@enterprisedb.com> wrote: >> > Hi, >> > >> > I have rebased the patch on latest commit with few cosmetic changes. >> > >> > The patch fix_listdatums_get_qual_for_list_v3.patch [1] needs to be >> applied >> > before applying this patch. >> > >> > [1] http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg >> 315490.html >> > >> >> >> This needs a rebase again. >> >> -- >> >> Beena Emerson >> >> EnterpriseDB: http://www.enterprisedb.com >> The Enterprise PostgreSQL Company >> > >
default_partition_v17.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
