fix regression tests for copied foreign keys

funbringer · funbringer · commit fe6e10cb8cd2 · 2016-09-06T19:12:45.000+03:00
diff --git a/expected/pg_pathman.out b/expected/pg_pathman.out
@@ -1724,6 +1724,7 @@ NOTICE:  sequence "test_fkey_seq" does not exist, skipping
 
 INSERT INTO test_fkey VALUES(1, 'wrong');
 ERROR:  insert or update on table "test_fkey_1" violates foreign key constraint "test_fkey_1_comment_fkey"
+INSERT INTO test_fkey VALUES(1, 'test');
 SELECT drop_partitions('test_fkey');
 NOTICE:  function public.test_fkey_upd_trig_func() does not exist, skipping
 NOTICE:  100 rows copied from test_fkey_10
@@ -1735,7 +1736,7 @@ NOTICE:  100 rows copied from test_fkey_5
 NOTICE:  100 rows copied from test_fkey_4
 NOTICE:  100 rows copied from test_fkey_3
 NOTICE:  100 rows copied from test_fkey_2
-NOTICE:  100 rows copied from test_fkey_1
+NOTICE:  101 rows copied from test_fkey_1
  drop_partitions 
 -----------------
               10
@@ -1749,6 +1750,7 @@ SELECT create_hash_partitions('test_fkey', 'id', 10);
 
 INSERT INTO test_fkey VALUES(1, 'wrong');
 ERROR:  insert or update on table "test_fkey_0" violates foreign key constraint "test_fkey_0_comment_fkey"
+INSERT INTO test_fkey VALUES(1, 'test');
 SELECT drop_partitions('test_fkey');
 NOTICE:  function public.test_fkey_upd_trig_func() does not exist, skipping
 NOTICE:  94 rows copied from test_fkey_9
@@ -1760,7 +1762,7 @@ NOTICE:  101 rows copied from test_fkey_4
 NOTICE:  116 rows copied from test_fkey_3
 NOTICE:  90 rows copied from test_fkey_2
 NOTICE:  90 rows copied from test_fkey_1
-NOTICE:  98 rows copied from test_fkey_0
+NOTICE:  100 rows copied from test_fkey_0
  drop_partitions 
 -----------------
               10
diff --git a/sql/pg_pathman.sql b/sql/pg_pathman.sql
@@ -662,5 +662,6 @@ INSERT INTO test_fkey VALUES(1, 'test');
 SELECT drop_partitions('test_fkey');
 
 SELECT create_hash_partitions('test_fkey', 'id', 10);
+INSERT INTO test_fkey VALUES(1, 'wrong');
 INSERT INTO test_fkey VALUES(1, 'test');
 SELECT drop_partitions('test_fkey');
