Hi,I have rebased the patch on the latest commit.PFA.There exists one issue reported by Rajkumar[1] off-line as following, wheredescribing the default partition after deleting null partition, does not showupdated 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 DEFAULTPartition constraint: ((c1 IS NOT NULL) AND (c1 <> ALL (ARRAY[1, 2, 10, 11])))postgres=# alter table t1 detach partition t14;ALTER TABLEpostgres=# \d+ t12 Table "public.t12" Column | Type | Collation | Nullable | Default | Storage | Stats target | Description --------+---------+-----------+----------+---------+---------+--------------+------------- c1 | integer | | | | plain | | Partition of: t1 DEFAULTPartition constraint: ((c1 IS NOT NULL) AND (c1 <> ALL (ARRAY[1, 2, 10, 11])))postgres=# insert into t1 values(null);INSERT 0 1Note that the parent correctly allows the nulls to be inserted.[1] rajkumar.raghuwanshi@enterprisedb.comRegards,Jeevan LadheOn Tue, May 30, 2017 at 10:59 AM, Beena Emerson <memissemerson@gmail.com> wrote:On Mon, May 29, 2017 at 9:33 PM, Jeevan Ladhe <jeevan.ladhe@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/msg315490.html >This needs a rebase again. -- Beena Emerson EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Mon, May 29, 2017 at 9:33 PM, Jeevan Ladhe <jeevan.ladhe@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/msg315490.html >This needs a rebase again. -- Beena Emerson EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных