*** /stuff/postgresql-9.2.7/src/test/regress/expected/inherit.out Mon Feb 17 13:38:15 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/inherit.out Tue Mar 11 16:55:26 2014 *************** *** 576,592 **** from ( select f1 from foo union all select f1+3 from foo ) ss where bar.f1 = ss.f1; select tableoid::regclass::text as relname, bar.* from bar order by 1,2; relname | f1 | f2 ---------+----+----- ! bar | 1 | 201 ! bar | 2 | 202 ! bar | 3 | 203 ! bar | 4 | 104 ! bar2 | 1 | 201 ! bar2 | 2 | 202 ! bar2 | 3 | 203 ! bar2 | 4 | 104 (8 rows) /* Test multiple inheritance of column defaults */ --- 576,593 ---- from ( select f1 from foo union all select f1+3 from foo ) ss where bar.f1 = ss.f1; + ERROR: rel 5 already exists select tableoid::regclass::text as relname, bar.* from bar order by 1,2; relname | f1 | f2 ---------+----+----- ! bar | 1 | 101 ! bar | 2 | 102 ! bar | 3 | 103 ! bar | 4 | 4 ! bar2 | 1 | 101 ! bar2 | 2 | 102 ! bar2 | 3 | 103 ! bar2 | 4 | 4 (8 rows) /* Test multiple inheritance of column defaults */ *************** *** 1391,1427 **** (SELECT unique1 AS x FROM tenk1 a UNION ALL SELECT unique2 AS x FROM tenk1 b) s; ! QUERY PLAN ! -------------------------------------------------------------------- ! Result ! InitPlan 1 (returns $0) ! -> Limit ! -> Merge Append ! Sort Key: a.unique1 ! -> Index Only Scan using tenk1_unique1 on tenk1 a ! Index Cond: (unique1 IS NOT NULL) ! -> Index Only Scan using tenk1_unique2 on tenk1 b ! Index Cond: (unique2 IS NOT NULL) ! (9 rows) ! explain (costs off) SELECT min(y) FROM (SELECT unique1 AS x, unique1 AS y FROM tenk1 a UNION ALL SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s; ! QUERY PLAN ! -------------------------------------------------------------------- ! Result ! InitPlan 1 (returns $0) ! -> Limit ! -> Merge Append ! Sort Key: a.unique1 ! -> Index Only Scan using tenk1_unique1 on tenk1 a ! Index Cond: (unique1 IS NOT NULL) ! -> Index Only Scan using tenk1_unique2 on tenk1 b ! Index Cond: (unique2 IS NOT NULL) ! (9 rows) ! -- XXX planner doesn't recognize that index on unique2 is sufficiently sorted explain (costs off) SELECT x, y FROM --- 1392,1404 ---- (SELECT unique1 AS x FROM tenk1 a UNION ALL SELECT unique2 AS x FROM tenk1 b) s; ! ERROR: rel 4 already exists explain (costs off) SELECT min(y) FROM (SELECT unique1 AS x, unique1 AS y FROM tenk1 a UNION ALL SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s; ! ERROR: rel 4 already exists -- XXX planner doesn't recognize that index on unique2 is sufficiently sorted explain (costs off) SELECT x, y FROM *************** *** 1429,1445 **** UNION ALL SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s ORDER BY x, y; ! QUERY PLAN ! ------------------------------------------------------------------- ! Result ! -> Merge Append ! Sort Key: a.thousand, a.tenthous ! -> Index Only Scan using tenk1_thous_tenthous on tenk1 a ! -> Sort ! Sort Key: b.unique2, b.unique2 ! -> Index Only Scan using tenk1_unique2 on tenk1 b ! (7 rows) ! reset enable_seqscan; reset enable_indexscan; reset enable_bitmapscan; --- 1406,1412 ---- UNION ALL SELECT unique2 AS x, unique2 AS y FROM tenk1 b) s ORDER BY x, y; ! ERROR: rel 4 already exists reset enable_seqscan; reset enable_indexscan; reset enable_bitmapscan; ====================================================================== *** /stuff/postgresql-9.2.7/src/test/regress/expected/union.out Mon Feb 17 13:38:15 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/union.out Tue Mar 11 16:55:32 2014 *************** *** 474,489 **** UNION ALL SELECT * FROM t2) t WHERE ab = 'ab'; ! QUERY PLAN ! --------------------------------------------------- ! Result ! -> Append ! -> Index Scan using t1_ab_idx on t1 ! Index Cond: ((a || b) = 'ab'::text) ! -> Index Only Scan using t2_pkey on t2 ! Index Cond: (ab = 'ab'::text) ! (6 rows) ! explain (costs off) SELECT * FROM (SELECT a || b AS ab FROM t1 --- 474,480 ---- UNION ALL SELECT * FROM t2) t WHERE ab = 'ab'; ! ERROR: rel 4 already exists explain (costs off) SELECT * FROM (SELECT a || b AS ab FROM t1 *************** *** 510,522 **** UNION ALL SELECT 2 AS t, * FROM tenk1 b) c WHERE t = 2; ! QUERY PLAN ! --------------------------------- ! Result ! -> Append ! -> Seq Scan on tenk1 b ! (3 rows) ! -- Test that we push quals into UNION sub-selects only when it's safe explain (costs off) SELECT * FROM --- 501,507 ---- UNION ALL SELECT 2 AS t, * FROM tenk1 b) c WHERE t = 2; ! ERROR: rel 4 already exists -- Test that we push quals into UNION sub-selects only when it's safe explain (costs off) SELECT * FROM *************** *** 617,641 **** select * from (select * from t3 a union all select * from t3 b) ss join int4_tbl on f1 = expensivefunc(x); ! QUERY PLAN ! ------------------------------------------------------------ ! Nested Loop ! -> Seq Scan on int4_tbl ! -> Append ! -> Index Scan using t3i on t3 a ! Index Cond: (expensivefunc(x) = int4_tbl.f1) ! -> Index Scan using t3i on t3 b ! Index Cond: (expensivefunc(x) = int4_tbl.f1) ! (7 rows) ! select * from (select * from t3 a union all select * from t3 b) ss join int4_tbl on f1 = expensivefunc(x); ! x | f1 ! ---+---- ! 0 | 0 ! 0 | 0 ! (2 rows) ! drop table t3; drop function expensivefunc(int); --- 602,611 ---- select * from (select * from t3 a union all select * from t3 b) ss join int4_tbl on f1 = expensivefunc(x); ! ERROR: rel 6 already exists select * from (select * from t3 a union all select * from t3 b) ss join int4_tbl on f1 = expensivefunc(x); ! ERROR: rel 6 already exists drop table t3; drop function expensivefunc(int); ====================================================================== *** /stuff/postgresql-9.2.7/src/test/regress/expected/security_label.out Tue Mar 11 16:53:52 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/security_label.out Tue Mar 11 16:55:37 2014 *************** *** 92,110 **** SECURITY LABEL ON SCHEMA seclabel_test IS 'unclassified'; -- OK SELECT objtype, objname, provider, label FROM pg_seclabels ORDER BY objtype, objname; ! objtype | objname | provider | label ! ----------+-----------------+----------+-------------- ! column | seclabel_tbl1.a | dummy | unclassified ! domain | seclabel_domain | dummy | classified ! function | seclabel_four() | dummy | classified ! role | seclabel_user1 | dummy | classified ! role | seclabel_user2 | dummy | unclassified ! schema | seclabel_test | dummy | unclassified ! table | seclabel_tbl1 | dummy | top secret ! table | seclabel_tbl2 | dummy | classified ! view | seclabel_view1 | dummy | classified ! (9 rows) ! -- clean up objects DROP FUNCTION seclabel_four(); DROP DOMAIN seclabel_domain; --- 92,98 ---- SECURITY LABEL ON SCHEMA seclabel_test IS 'unclassified'; -- OK SELECT objtype, objname, provider, label FROM pg_seclabels ORDER BY objtype, objname; ! ERROR: rel 16 already exists -- clean up objects DROP FUNCTION seclabel_four(); DROP DOMAIN seclabel_domain; *************** *** 117,123 **** -- make sure we don't have any leftovers SELECT objtype, objname, provider, label FROM pg_seclabels ORDER BY objtype, objname; ! objtype | objname | provider | label ! ---------+---------+----------+------- ! (0 rows) ! --- 105,108 ---- -- make sure we don't have any leftovers SELECT objtype, objname, provider, label FROM pg_seclabels ORDER BY objtype, objname; ! ERROR: rel 16 already exists ====================================================================== *** /stuff/postgresql-9.2.7/src/test/regress/expected/foreign_data.out Mon Feb 17 13:38:15 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/foreign_data.out Tue Mar 11 16:55:46 2014 *************** *** 900,922 **** (7 rows) SELECT * FROM information_schema.usage_privileges WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! grantor | grantee | object_catalog | object_schema | object_name | object_type | privilege_type | is_grantable ! -------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+-------------- ! foreign_data_user | foreign_data_user | regression | | foo | FOREIGN DATA WRAPPER | USAGE | YES ! foreign_data_user | foreign_data_user | regression | | s6 | FOREIGN SERVER | USAGE | YES ! foreign_data_user | regress_test_indirect | regression | | foo | FOREIGN DATA WRAPPER | USAGE | NO ! foreign_data_user | regress_test_role2 | regression | | s6 | FOREIGN SERVER | USAGE | YES ! (4 rows) ! SELECT * FROM information_schema.role_usage_grants WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! grantor | grantee | object_catalog | object_schema | object_name | object_type | privilege_type | is_grantable ! -------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+-------------- ! foreign_data_user | foreign_data_user | regression | | foo | FOREIGN DATA WRAPPER | USAGE | YES ! foreign_data_user | foreign_data_user | regression | | s6 | FOREIGN SERVER | USAGE | YES ! foreign_data_user | regress_test_indirect | regression | | foo | FOREIGN DATA WRAPPER | USAGE | NO ! foreign_data_user | regress_test_role2 | regression | | s6 | FOREIGN SERVER | USAGE | YES ! (4 rows) ! SELECT * FROM information_schema.foreign_tables ORDER BY 1, 2, 3; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+--------------------+------------------------+--------------------- --- 900,908 ---- (7 rows) SELECT * FROM information_schema.usage_privileges WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! ERROR: could not open relation with OID 0 SELECT * FROM information_schema.role_usage_grants WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! ERROR: could not open relation with OID 0 SELECT * FROM information_schema.foreign_tables ORDER BY 1, 2, 3; foreign_table_catalog | foreign_table_schema | foreign_table_name | foreign_server_catalog | foreign_server_name -----------------------+----------------------+--------------------+------------------------+--------------------- *************** *** 943,961 **** (5 rows) SELECT * FROM information_schema.usage_privileges WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! grantor | grantee | object_catalog | object_schema | object_name | object_type | privilege_type | is_grantable ! -------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+-------------- ! foreign_data_user | regress_test_indirect | regression | | foo | FOREIGN DATA WRAPPER | USAGE | NO ! foreign_data_user | regress_test_role2 | regression | | s6 | FOREIGN SERVER | USAGE | YES ! (2 rows) ! SELECT * FROM information_schema.role_usage_grants WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! grantor | grantee | object_catalog | object_schema | object_name | object_type | privilege_type | is_grantable ! -------------------+-----------------------+----------------+---------------+-------------+----------------------+----------------+-------------- ! foreign_data_user | regress_test_indirect | regression | | foo | FOREIGN DATA WRAPPER | USAGE | NO ! foreign_data_user | regress_test_role2 | regression | | s6 | FOREIGN SERVER | USAGE | YES ! (2 rows) ! DROP USER MAPPING FOR current_user SERVER t1; SET ROLE regress_test_role2; SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2, 3, 4; --- 929,937 ---- (5 rows) SELECT * FROM information_schema.usage_privileges WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! ERROR: rel 11 already exists SELECT * FROM information_schema.role_usage_grants WHERE object_type LIKE 'FOREIGN%' AND object_name IN ('s6', 'foo') ORDER BY 1, 2, 3, 4, 5; ! ERROR: rel 14 already exists DROP USER MAPPING FOR current_user SERVER t1; SET ROLE regress_test_role2; SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2, 3, 4; ====================================================================== *** /stuff/postgresql-9.2.7/src/test/regress/expected/window.out Mon Feb 17 13:38:15 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/window.out Tue Mar 11 16:55:44 2014 *************** *** 957,966 **** -- with UNION SELECT count(*) OVER (PARTITION BY four) FROM (SELECT * FROM tenk1 UNION ALL SELECT * FROM tenk2)s LIMIT 0; ! count ! ------- ! (0 rows) ! -- ordering by a non-integer constant is allowed SELECT rank() OVER (ORDER BY length('abc')); rank --- 957,963 ---- -- with UNION SELECT count(*) OVER (PARTITION BY four) FROM (SELECT * FROM tenk1 UNION ALL SELECT * FROM tenk2)s LIMIT 0; ! ERROR: rel 4 already exists -- ordering by a non-integer constant is allowed SELECT rank() OVER (ORDER BY length('abc')); rank ====================================================================== *** /stuff/postgresql-9.2.7/src/test/regress/expected/with.out Mon Feb 17 13:38:15 2014 --- /stuff/postgresql-9.2.7/src/test/regress/results/with.out Tue Mar 11 16:55:57 2014 *************** *** 384,396 **** (SELECT 2 AS i UNION ALL SELECT 3 AS i) AS t2 JOIN t ON (t2.i = t.i+1)) SELECT * FROM t; ! i | j ! ---+--- ! 1 | 2 ! 2 | 3 ! 3 | 4 ! (3 rows) ! -- -- different tree example -- --- 384,390 ---- (SELECT 2 AS i UNION ALL SELECT 3 AS i) AS t2 JOIN t ON (t2.i = t.i+1)) SELECT * FROM t; ! ERROR: rel 6 already exists -- -- different tree example -- ======================================================================