regression.32.diffs

--- /home/amitkapila/mywork/pgcommit/postgresql/contrib/amcheck/expected/check_btree.out	2019-01-26 17:53:22.461534128 +0530
+++ /home/amitkapila/mywork/pgcommit/postgresql/contrib/amcheck/results/check_btree.out	2019-01-31 10:05:02.774450203 +0530
@@ -31,119 +31,7 @@
 GRANT EXECUTE ON FUNCTION bt_index_parent_check(regclass, boolean) TO bttest_role;
 SET ROLE bttest_role;
 SELECT bt_index_check('bttest_a_idx');
- bt_index_check 
-----------------
- 
-(1 row)
-
-SELECT bt_index_parent_check('bttest_a_idx');
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
-RESET ROLE;
--- verify plain tables are rejected (error)
-SELECT bt_index_check('bttest_a');
-ERROR:  "bttest_a" is not an index
-SELECT bt_index_parent_check('bttest_a');
-ERROR:  "bttest_a" is not an index
--- verify non-existing indexes are rejected (error)
-SELECT bt_index_check(17);
-ERROR:  could not open relation with OID 17
-SELECT bt_index_parent_check(17);
-ERROR:  could not open relation with OID 17
--- verify wrong index types are rejected (error)
-BEGIN;
-CREATE INDEX bttest_a_brin_idx ON bttest_a USING brin(id);
-SELECT bt_index_parent_check('bttest_a_brin_idx');
-ERROR:  only B-Tree indexes are supported as targets for verification
-DETAIL:  Relation "bttest_a_brin_idx" is not a B-Tree index.
-ROLLBACK;
--- normal check outside of xact
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check 
-----------------
- 
-(1 row)
-
--- more expansive tests
-SELECT bt_index_check('bttest_a_idx', true);
- bt_index_check 
-----------------
- 
-(1 row)
-
-SELECT bt_index_parent_check('bttest_b_idx', true);
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
-BEGIN;
-SELECT bt_index_check('bttest_a_idx');
- bt_index_check 
-----------------
- 
-(1 row)
-
-SELECT bt_index_parent_check('bttest_b_idx');
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
--- make sure we don't have any leftover locks
-SELECT * FROM pg_locks
-WHERE relation = ANY(ARRAY['bttest_a', 'bttest_a_idx', 'bttest_b', 'bttest_b_idx']::regclass[])
-    AND pid = pg_backend_pid();
- locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath 
-----------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-----+------+---------+----------
-(0 rows)
-
-COMMIT;
--- normal check outside of xact for index with included columns
-SELECT bt_index_check('bttest_multi_idx');
- bt_index_check 
-----------------
- 
-(1 row)
-
--- more expansive test for index with included columns
-SELECT bt_index_parent_check('bttest_multi_idx', true);
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
--- repeat expansive test for index built using insertions
-TRUNCATE bttest_multi;
-INSERT INTO bttest_multi SELECT i, i%2  FROM generate_series(1, 100000) as i;
-SELECT bt_index_parent_check('bttest_multi_idx', true);
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
---
--- Test for multilevel page deletion/downlink present checks
---
-INSERT INTO delete_test_table SELECT i, 1, 2, 3 FROM generate_series(1,80000) i;
-ALTER TABLE delete_test_table ADD PRIMARY KEY (a,b,c,d);
-DELETE FROM delete_test_table WHERE a > 40000;
-VACUUM delete_test_table;
-DELETE FROM delete_test_table WHERE a > 10;
-VACUUM delete_test_table;
-SELECT bt_index_parent_check('delete_test_table_pkey', true);
- bt_index_parent_check 
------------------------
- 
-(1 row)
-
--- cleanup
-DROP TABLE bttest_a;
-DROP TABLE bttest_b;
-DROP TABLE bttest_multi;
-DROP TABLE delete_test_table;
-DROP OWNED BY bttest_role; -- permissions
-DROP ROLE bttest_role;
+server closed the connection unexpectedly
+	This probably means the server terminated abnormally
+	before or while processing the request.
+connection to server was lost

======================================================================