We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent158b7bc commit22ff2b8Copy full SHA for 22ff2b8
src/test/regress/expected/insert_conflict.out
@@ -884,9 +884,13 @@ insert into parted_conflict values (40, 'forty');
884
insert into parted_conflict_1 values (40, 'cuarenta')
885
on conflict (a) do update set b = excluded.b;
886
ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
887
+drop table parted_conflict;
888
-- test whole-row Vars in ON CONFLICT expressions
889
+create table parted_conflict (a int, b text, c int) partition by range (a);
890
+create table parted_conflict_1 (drp text, c int, a int, b text);
891
+alter table parted_conflict_1 drop column drp;
892
create unique index on parted_conflict (a, b);
-alter table parted_conflictadd c int;
893
+alter table parted_conflictattach partition parted_conflict_1 for values from (0) to (1000);
894
truncate parted_conflict;
895
insert into parted_conflict values (50, 'cincuenta', 1);
896
insert into parted_conflict values (50, 'cincuenta', 2)