if (map!=NULL)

{

tuple=do_convert_tuple(tuple,map);

ExecSetSlotDescriptor(slot,tupdesc);

ExecStoreTuple(tuple,slot,InvalidBuffer, false);

}

}

if (map!=NULL)

{

tuple=do_convert_tuple(tuple,map);

ExecSetSlotDescriptor(slot,tupdesc);

ExecStoreTuple(tuple,slot,InvalidBuffer, false);

}

}

if (map!=NULL)

{

tuple=do_convert_tuple(tuple,map);

ExecSetSlotDescriptor(slot,tupdesc);

ExecStoreTuple(tuple,slot,InvalidBuffer, false);

}

}

if (map!=NULL)

{

tuple=do_convert_tuple(tuple,map);

ExecSetSlotDescriptor(slot,tupdesc);

ExecStoreTuple(tuple,slot,InvalidBuffer, false);

}

}

mlparted4 | 1 | 30 | 39

(5 rows)

alter table mlparted add c text;

create table mlparted5 (c text, a int not null, b int not null) partition by list (c);

create table mlparted5a (a int not null, c text, b int not null);

alter table mlparted5 attach partition mlparted5a for values in ('a');

alter table mlparted attach partition mlparted5 for values from (1, 40) to (1, 50);

alter table mlparted add constraint check_b check (a = 1 and b < 45);

insert into mlparted values (1, 45, 'a');

ERROR: new row for relation "mlparted5a" violates check constraint "check_b"

DETAIL: Failing row contains (1, 45, a).

create function mlparted5abrtrig_func() returns trigger as $$ begin new.c = 'b'; return new; end; $$ language plpgsql;

create trigger mlparted5abrtrig before insert on mlparted5a for each row execute procedure mlparted5abrtrig_func();

insert into mlparted5 (a, b, c) values (1, 40, 'a');

ERROR: new row for relation "mlparted5a" violates partition constraint

DETAIL: Failing row contains (b, 1, 40).

drop table mlparted5;

-- check that message shown after failure to find a partition shows the

-- appropriate key description (or none) in various situations

create table key_desc (a int, b int) partition by list ((a+0));

DROP VIEW v1;

DROP TABLE t1;

-- check that an auto-updatable view on a partitioned table works correctly

create table pt (a int, b int) partition by range (a, b);

create table pt1 (b int not null, a int not null) partition by range (b);

create table pt (a int, b int, v varchar) partition by range (a, b);

create table pt1 (b int not null,v varchar,a int not null) partition by range (b);

create table pt11 (like pt1);

alter table pt11 drop a;

alter table pt11 add a int;

------------+-------------+--------------

ptv | a | YES

ptv | b | YES

(2 rows)

ptv | v | YES

(3 rows)

insert into ptv values (1, 2);

select tableoid::regclass, * from pt;

tableoid | a | b

----------+---+---

pt11 | 1 | 2

tableoid | a | b| v

----------+---+---+---

pt11 | 1 | 2 |

(1 row)

create view ptv_wco as select * from pt where a = 0 with check option;

insert into ptv_wco values (1, 2);

ERROR: new row violates check option for view "ptv_wco"

DETAIL: Failing row contains (1, 2).

DETAIL: Failing row contains (1, 2, null).

drop view ptv, ptv_wco;

drop table pt, pt1, pt11;

(insert into mlparted (b, a)selects.a,1from generate_series(2,39) s(a) returning tableoid::regclass,*)

select a, b,min(c),max(c)from insgroup by a, border by1;

altertable mlparted add ctext;

createtablemlparted5 (ctext, aintnot null, bintnot null) partition by list (c);

createtablemlparted5a (aintnot null, ctext, bintnot null);

altertable mlparted5 attach partition mlparted5a forvaluesin ('a');

altertable mlparted attach partition mlparted5 forvaluesfrom (1,40) to (1,50);

altertable mlparted addconstraint check_bcheck (a=1and b<45);

insert into mlpartedvalues (1,45,'a');

createfunctionmlparted5abrtrig_func() returns triggeras $$beginnew.c='b'; return new; end; $$ language plpgsql;

createtriggermlparted5abrtrig before inserton mlparted5a for each row execute procedure mlparted5abrtrig_func();

insert into mlparted5 (a, b, c)values (1,40,'a');

droptable mlparted5;

createtablekey_desc (aint, bint) partition by list ((a+0));

DROPTABLE t1;

createtablept (aint, bint) partition by range (a, b);

createtablept1 (bintnot null, aintnot null) partition by range (b);

createtablept (aint, bint, vvarchar) partition by range (a, b);

createtablept1 (bintnot null,vvarchar,aintnot null) partition by range (b);

createtablept11 (like pt1);

altertable pt11 drop a;

altertable pt11 add aint;