Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ewIgn-0005TY-Ci for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Mar 2018 02:32:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ewIgl-0006fg-HE for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Mar 2018 02:32:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ewIgl-0006fX-8J for pgsql-hackers@lists.postgresql.org; Thu, 15 Mar 2018 02:32:19 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ewIgf-00067T-7k for pgsql-hackers@lists.postgresql.org; Thu, 15 Mar 2018 02:32:18 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w2F2WASu016739; Wed, 14 Mar 2018 22:32:10 -0400 From: Tom Lane To: Thomas Munro cc: PostgreSQL Hackers Subject: Re: Instability in parallel regression tests In-reply-to: References: <4627.1521070268@sss.pgh.pa.us> Comments: In-reply-to Thomas Munro message dated "Thu, 15 Mar 2018 14:57:47 +1300" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----- =_aaaaaaaaaa0" Content-ID: <16511.1521080854.0@sss.pgh.pa.us> Date: Wed, 14 Mar 2018 22:32:10 -0400 Message-ID: <16738.1521081130@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------- =_aaaaaaaaaa0 Content-Type: text/plain; charset="us-ascii" Content-ID: <16511.1521080854.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Thomas Munro writes: > On Thu, Mar 15, 2018 at 12:31 PM, Tom Lane wrote: >> Moral: choose names less generic than "test" for globally-visible >> objects. I wonder if there's some way we could check for such >> conflicts automatically? > Ugh. Yeah. Non-temporary table and view names used in more than one .s= ql file: > $ ( for F in src/test/regress/sql/*.sql ; do perl -ne '/create > *(table|view) ([^ (]+)/i && print "$2\n";' < $F | sort | uniq ; done ) > | sort | uniq -d I've just been investigating this a different way, which is to insert some quick-hack logging (patch attached for amusement). I manually filtered out a bunch of non-problems, in particular discarding names that are in per-test schemas; I think it's all right to allow tests that are taking that precaution to do what they like name-wise. I'm still left with a bunch of stuff that looks ill-considered. It's worth singling out the partitioned-table work, in particular, as deserving of an F on this test. Those patches have shown no hesitation about using the same public-schema table names in three or four different test scripts. It happens that most of that is in create_table, alter_table, insert, and update, which happen not to run concurrently; but I don't think those tests have any business depending on that. Other thoughts: * We should simply ban the use of "foo", "bar", "baz", "test...", and "tmp..." as names; at least, don't do that without adding a prefix or suffix that is unique to the particular test script. * The prefix "my_" is not yours. * We have a project policy that role names created during the tests should start with "regress_". Obey that, but don't imagine that doing so is enough to make your name unique. Actual or potential trouble spots according to my filtering: [alter_table] LOG: CREATING FUNCTION 2200/dummy_hashint4 [insert] LOG: CREATING FUNCTION 2200/dummy_hashint4 [update] LOG: CREATING FUNCTION 2200/dummy_hashint4 [rangefuncs] LOG: CREATING FUNCTION 2200/foo [rangefuncs] LOG: CREATING FUNCTION 2200/foo [rangefuncs] LOG: CREATING FUNCTION 2200/foo [rangefuncs] LOG: CREATING FUNCTION 2200/foo [rangefuncs] LOG: CREATING FUNCTION 2200/foo1 [rangefuncs] LOG: CREATING FUNCTION 2200/foo_mat [rangefuncs] LOG: CREATING FUNCTION 2200/foo_sql [rangefuncs] LOG: CREATING FUNCTION 2200/foob [rangefuncs] LOG: CREATING FUNCTION 2200/foobar [rangefuncs] LOG: CREATING FUNCTION 2200/foobar [select_parallel] LOG: CREATING FUNCTION 2200/foobar [rangefuncs] LOG: CREATING FUNCTION 2200/foor [rangefuncs] LOG: CREATING FUNCTION 2200/foot [plpgsql] LOG: CREATING FUNCTION 2200/footest [plpgsql] LOG: CREATING FUNCTION 2200/footest [plpgsql] LOG: CREATING FUNCTION 2200/simple_func [select_parallel] LOG: CREATING FUNCTION 2200/simple_func [create_aggregate] LOG: CREATING FUNCTION 2200/sum3 [polymorphism] LOG: CREATING FUNCTION 2200/sum3 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [create_function_1] LOG: CREATING FUNCTION 2200/test1 [privileges] LOG: CREATING FUNCTION 2200/testagg1 [rolenames] LOG: CREATING FUNCTION 2200/testagg1 [privileges] LOG: CREATING FUNCTION 2200/testagg1b [rolenames] LOG: CREATING FUNCTION 2200/testagg2 [rolenames] LOG: CREATING FUNCTION 2200/testagg3 [rolenames] LOG: CREATING FUNCTION 2200/testagg4 [rolenames] LOG: CREATING FUNCTION 2200/testagg5 [rolenames] LOG: CREATING FUNCTION 2200/testagg6 [rolenames] LOG: CREATING FUNCTION 2200/testagg7 [rolenames] LOG: CREATING FUNCTION 2200/testagg8 [rolenames] LOG: CREATING FUNCTION 2200/testagg9 would be a live hazard, except the functions have different arguments: [polymorphism] LOG: CREATING FUNCTION 2200/testfoo [polymorphism] LOG: CREATING FUNCTION 2200/testfoo [rangefuncs] LOG: CREATING FUNCTION 2200/testfoo [rangefuncs] LOG: CREATING FUNCTION 2200/testfoo [create_procedure] LOG: CREATING FUNCTION 2200/testfunc1 [privileges] LOG: CREATING FUNCTION 2200/testfunc1 [privileges] LOG: CREATING FUNCTION 2200/testfunc2 [privileges] LOG: CREATING FUNCTION 2200/testfunc4 [privileges] LOG: CREATING FUNCTION 2200/testfunc5b [privileges] LOG: CREATING FUNCTION 2200/testfunc6b [select_into] LOG: CREATING RELATION 102018/tmp1 [select_into] LOG: CREATING RELATION 102018/tmp1 [select_into] LOG: CREATING RELATION 102018/tmp2 [select_into] LOG: CREATING RELATION 102018/tmp2 [select_into] LOG: CREATING RELATION 102018/tmp3 [select_into] LOG: CREATING RELATION 102018/tmp3 [alter_table] LOG: CREATING RELATION 2200/atacc1 [constraints] LOG: CREATING RELATION 2200/atacc1 [constraints] LOG: CREATING RELATION 2200/atacc1 [alter_table] LOG: CREATING RELATION 2200/atacc1_id_seq [constraints] LOG: CREATING RELATION 2200/atacc2 [constraints] LOG: CREATING RELATION 2200/atacc2 [alter_table] LOG: CREATING RELATION 2200/atacc2_id_key live hazard: [join] LOG: CREATING RELATION 2200/bar [transactions] LOG: CREATING RELATION 2200/bar [transactions] LOG: CREATING RELATION 2200/barbaz [transactions] LOG: CREATING RELATION 2200/baz [bitmapops] LOG: CREATING RELATION 2200/bmscantest [select_parallel] LOG: CREATING RELATION 2200/bmscantest [alter_table] LOG: CREATING RELATION 2200/c1 [alter_table] LOG: CREATING RELATION 2200/c1 [alter_table] LOG: CREATING RELATION 2200/c1 [alter_table] LOG: CREATING RELATION 2200/c1 [alter_table] LOG: CREATING RELATION 2200/c1 [inherit] LOG: CREATING RELATION 2200/c1 [inherit] LOG: CREATING RELATION 2200/c1 [inherit] LOG: CREATING RELATION 2200/c1 [inherit] LOG: CREATING RELATION 2200/c2 [inherit] LOG: CREATING RELATION 2200/c2 [inherit] LOG: CREATING RELATION 2200/c3 [alter_table] LOG: CREATING RELATION 2200/child [alter_table] LOG: CREATING RELATION 2200/child [alter_table] LOG: CREATING RELATION 2200/child [triggers] LOG: CREATING RELATION 2200/child [triggers] LOG: CREATING RELATION 2200/child [triggers] LOG: CREATING RELATION 2200/child1 [triggers] LOG: CREATING RELATION 2200/child1 [triggers] LOG: CREATING RELATION 2200/child2 [triggers] LOG: CREATING RELATION 2200/child2 [triggers] LOG: CREATING RELATION 2200/child3 [triggers] LOG: CREATING RELATION 2200/child3 [alter_table] LOG: CREATING RELATION 2200/child_noinh_convalid [arrays] LOG: CREATING RELATION 2200/comptable [arrays] LOG: CREATING RELATION 2200/comptype [domain] LOG: CREATING RELATION 2200/comptype [domain] LOG: CREATING RELATION 2200/comptype [domain] LOG: CREATING RELATION 2200/comptype [alter_table] LOG: CREATING RELATION 2200/fail_part [alter_table] LOG: CREATING RELATION 2200/fail_part [create_table] LOG: CREATING RELATION 2200/fail_part [create_table] LOG: CREATING RELATION 2200/fail_part [create_table] LOG: CREATING RELATION 2200/fail_part_col_not_found live hazard join vs transactions: [join] LOG: CREATING RELATION 2200/foo [rangefuncs] LOG: CREATING RELATION 2200/foo [rules] LOG: CREATING RELATION 2200/foo [transactions] LOG: CREATING RELATION 2200/foo [rangefuncs] LOG: CREATING RELATION 2200/foo2 [rangefuncs] LOG: CREATING RELATION 2200/foo2 [rules] LOG: CREATING RELATION 2200/foo2 [rangefuncs] LOG: CREATING RELATION 2200/foo_pkey [rangefuncs] LOG: CREATING RELATION 2200/foo_rescan_t [sequence] LOG: CREATING RELATION 2200/foo_seq [transactions] LOG: CREATING RELATION 2200/foobar [rules] LOG: CREATING RELATION 2200/fooview [rules] LOG: CREATING RELATION 2200/fooview [rules] LOG: CREATING RELATION 2200/fooview [rules] LOG: CREATING RELATION 2200/fooview_part [alter_table] LOG: CREATING RELATION 2200/hash_parted [create_table] LOG: CREATING RELATION 2200/hash_parted [insert] LOG: CREATING RELATION 2200/hash_parted [update] LOG: CREATING RELATION 2200/hash_parted [create_table] LOG: CREATING RELATION 2200/hash_parted2 [insert] LOG: CREATING RELATION 2200/hpart0 [insert] LOG: CREATING RELATION 2200/hpart1 [update] LOG: CREATING RELATION 2200/hpart1 [insert] LOG: CREATING RELATION 2200/hpart2 [update] LOG: CREATING RELATION 2200/hpart2 [insert] LOG: CREATING RELATION 2200/hpart3 [update] LOG: CREATING RELATION 2200/hpart3 [update] LOG: CREATING RELATION 2200/hpart4 [alter_table] LOG: CREATING RELATION 2200/hpart_1 [create_table] LOG: CREATING RELATION 2200/hpart_1 [alter_table] LOG: CREATING RELATION 2200/hpart_2 [create_table] LOG: CREATING RELATION 2200/hpart_2 [create_table] LOG: CREATING RELATION 2200/hpart_3 [alter_table] LOG: CREATING RELATION 2200/hpart_5 [alter_table] LOG: CREATING RELATION 2200/hpart_5_a [update] LOG: CREATING RELATION 2200/list_part1 [update] LOG: CREATING RELATION 2200/list_part1 [plancache] LOG: CREATING RELATION 2200/list_part_1 [plancache] LOG: CREATING RELATION 2200/list_part_2 [plancache] LOG: CREATING RELATION 2200/list_part_def [plancache] LOG: CREATING RELATION 2200/list_part_null [alter_table] LOG: CREATING RELATION 2200/list_parted [create_table] LOG: CREATING RELATION 2200/list_parted [inherit] LOG: CREATING RELATION 2200/list_parted [insert] LOG: CREATING RELATION 2200/list_parted [insert] LOG: CREATING RELATION 2200/list_parted [plancache] LOG: CREATING RELATION 2200/list_parted [update] LOG: CREATING RELATION 2200/list_parted [update] LOG: CREATING RELATION 2200/list_parted [alter_table] LOG: CREATING RELATION 2200/list_parted2 [create_table] LOG: CREATING RELATION 2200/list_parted2 [alter_table] LOG: CREATING RELATION 2200/list_parted2_def [create_table] LOG: CREATING RELATION 2200/list_parted2_def [inherit] LOG: CREATING RELATION 2200/mcrparted [insert] LOG: CREATING RELATION 2200/mcrparted [insert] LOG: CREATING RELATION 2200/mcrparted [inherit] LOG: CREATING RELATION 2200/mcrparted0 [insert] LOG: CREATING RELATION 2200/mcrparted0 [insert] LOG: CREATING RELATION 2200/mcrparted0 [inherit] LOG: CREATING RELATION 2200/mcrparted1 [insert] LOG: CREATING RELATION 2200/mcrparted1 [insert] LOG: CREATING RELATION 2200/mcrparted1_lt_b [inherit] LOG: CREATING RELATION 2200/mcrparted2 [insert] LOG: CREATING RELATION 2200/mcrparted2 [insert] LOG: CREATING RELATION 2200/mcrparted2 [insert] LOG: CREATING RELATION 2200/mcrparted2_b [inherit] LOG: CREATING RELATION 2200/mcrparted3 [insert] LOG: CREATING RELATION 2200/mcrparted3 [insert] LOG: CREATING RELATION 2200/mcrparted3_c_to_common [inherit] LOG: CREATING RELATION 2200/mcrparted4 [insert] LOG: CREATING RELATION 2200/mcrparted4 [insert] LOG: CREATING RELATION 2200/mcrparted4 [insert] LOG: CREATING RELATION 2200/mcrparted4_common_lt_0 [inherit] LOG: CREATING RELATION 2200/mcrparted5 [insert] LOG: CREATING RELATION 2200/mcrparted5 [insert] LOG: CREATING RELATION 2200/mcrparted5_common_0_to_10 [insert] LOG: CREATING RELATION 2200/mcrparted6_common_ge_10 [insert] LOG: CREATING RELATION 2200/mcrparted7_gt_common_lt_d [insert] LOG: CREATING RELATION 2200/mcrparted8_ge_d [inherit] LOG: CREATING RELATION 2200/mcrparted_def [insert] LOG: CREATING RELATION 2200/mlparted [insert] LOG: CREATING RELATION 2200/mlparted1 [insert] LOG: CREATING RELATION 2200/mlparted11 [insert] LOG: CREATING RELATION 2200/mlparted12 [insert] LOG: CREATING RELATION 2200/mlparted2 [insert] LOG: CREATING RELATION 2200/mlparted3 [insert] LOG: CREATING RELATION 2200/mlparted4 [insert] LOG: CREATING RELATION 2200/mlparted5 [insert] LOG: CREATING RELATION 2200/mlparted5a [insert] LOG: CREATING RELATION 2200/mlparted_def [insert] LOG: CREATING RELATION 2200/mlparted_def1 [insert] LOG: CREATING RELATION 2200/mlparted_def2 [insert] LOG: CREATING RELATION 2200/mlparted_defd [inherit] LOG: CREATING RELATION 2200/mlparted_tab [inherit] LOG: CREATING RELATION 2200/mlparted_tab_part1 [inherit] LOG: CREATING RELATION 2200/mlparted_tab_part2 [inherit] LOG: CREATING RELATION 2200/mlparted_tab_part2a [inherit] LOG: CREATING RELATION 2200/mlparted_tab_part2b [inherit] LOG: CREATING RELATION 2200/mlparted_tab_part3 [alter_table] LOG: CREATING RELATION 2200/p [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p1 [inherit] LOG: CREATING RELATION 2200/p1 [inherit] LOG: CREATING RELATION 2200/p1 [inherit] LOG: CREATING RELATION 2200/p1 [inherit] LOG: CREATING RELATION 2200/p1 [alter_table] LOG: CREATING RELATION 2200/p11 [inherit] LOG: CREATING RELATION 2200/p1_c1 [alter_table] LOG: CREATING RELATION 2200/p2 [inherit] LOG: CREATING RELATION 2200/p2 [inherit] LOG: CREATING RELATION 2200/p2 [alter_table] LOG: CREATING RELATION 2200/parent [alter_table] LOG: CREATING RELATION 2200/parent [alter_table] LOG: CREATING RELATION 2200/parent [alter_table] LOG: CREATING RELATION 2200/parent [triggers] LOG: CREATING RELATION 2200/parent [triggers] LOG: CREATING RELATION 2200/parent [triggers] LOG: CREATING RELATION 2200/parent [triggers] LOG: CREATING RELATION 2200/parent [triggers] LOG: CREATING RELATION 2200/parent_b_idx [alter_table] LOG: CREATING RELATION 2200/parent_noinh_convalid [create_table] LOG: CREATING RELATION 2200/part0 [create_table] LOG: CREATING RELATION 2200/part00 [alter_table] LOG: CREATING RELATION 2200/part1 [create_table] LOG: CREATING RELATION 2200/part1 [insert] LOG: CREATING RELATION 2200/part1 [create_table] LOG: CREATING RELATION 2200/part10 [create_table] LOG: CREATING RELATION 2200/part11 [create_table] LOG: CREATING RELATION 2200/part12 [alter_table] LOG: CREATING RELATION 2200/part2 [create_table] LOG: CREATING RELATION 2200/part2 [insert] LOG: CREATING RELATION 2200/part2 [create_table] LOG: CREATING RELATION 2200/part2_1 [alter_table] LOG: CREATING RELATION 2200/part3 [create_table] LOG: CREATING RELATION 2200/part3 [insert] LOG: CREATING RELATION 2200/part3 [create_table] LOG: CREATING RELATION 2200/part4 [insert] LOG: CREATING RELATION 2200/part4 [alter_table] LOG: CREATING RELATION 2200/part5_def [alter_table] LOG: CREATING RELATION 2200/part5_def_p1 [alter_table] LOG: CREATING RELATION 2200/part5_p1 [alter_table] LOG: CREATING RELATION 2200/part_1 [create_table] LOG: CREATING RELATION 2200/part_1 [inherit] LOG: CREATING RELATION 2200/part_10_20 [inherit] LOG: CREATING RELATION 2200/part_10_20_ab [inherit] LOG: CREATING RELATION 2200/part_10_20_cd [inherit] LOG: CREATING RELATION 2200/part_1_10 [inherit] LOG: CREATING RELATION 2200/part_1_10_ab [inherit] LOG: CREATING RELATION 2200/part_1_10_cd [alter_table] LOG: CREATING RELATION 2200/part_2 [create_table] LOG: CREATING RELATION 2200/part_2 [inherit] LOG: CREATING RELATION 2200/part_21_30 [inherit] LOG: CREATING RELATION 2200/part_21_30_ab [inherit] LOG: CREATING RELATION 2200/part_21_30_cd [alter_table] LOG: CREATING RELATION 2200/part_3 [alter_table] LOG: CREATING RELATION 2200/part_3_4 [inherit] LOG: CREATING RELATION 2200/part_40_inf [inherit] LOG: CREATING RELATION 2200/part_40_inf_ab [inherit] LOG: CREATING RELATION 2200/part_40_inf_cd [inherit] LOG: CREATING RELATION 2200/part_40_inf_null [alter_table] LOG: CREATING RELATION 2200/part_5 [alter_table] LOG: CREATING RELATION 2200/part_55_66 [alter_table] LOG: CREATING RELATION 2200/part_5_a [alter_table] LOG: CREATING RELATION 2200/part_6 [alter_table] LOG: CREATING RELATION 2200/part_7 [alter_table] LOG: CREATING RELATION 2200/part_7_a_null [create_table] LOG: CREATING RELATION 2200/part_a [update] LOG: CREATING RELATION 2200/part_a_10_a_20 [update] LOG: CREATING RELATION 2200/part_a_1_a_10 [insert] LOG: CREATING RELATION 2200/part_aa_bb [create_table] LOG: CREATING RELATION 2200/part_ab [inherit] LOG: CREATING RELATION 2200/part_ab_cd [create_table] LOG: CREATING RELATION 2200/part_b [update] LOG: CREATING RELATION 2200/part_b_10_b_20 [update] LOG: CREATING RELATION 2200/part_b_1_b_10 [update] LOG: CREATING RELATION 2200/part_b_20_b_30 [create_table] LOG: CREATING RELATION 2200/part_c [update] LOG: CREATING RELATION 2200/part_c_100_200 [create_table] LOG: CREATING RELATION 2200/part_c_1_10 [update] LOG: CREATING RELATION 2200/part_c_1_100 [insert] LOG: CREATING RELATION 2200/part_cc_dd [insert_conflict] LOG: CREATING RELATION 2200/part_comp_key_index [update] LOG: CREATING RELATION 2200/part_d_15_20 [update] LOG: CREATING RELATION 2200/part_d_1_15 [insert] LOG: CREATING RELATION 2200/part_def [update] LOG: CREATING RELATION 2200/part_def [create_table] LOG: CREATING RELATION 2200/part_default [insert] LOG: CREATING RELATION 2200/part_default [insert] LOG: CREATING RELATION 2200/part_default [insert] LOG: CREATING RELATION 2200/part_default [insert] LOG: CREATING RELATION 2200/part_default_p1 [insert] LOG: CREATING RELATION 2200/part_default_p2 [insert] LOG: CREATING RELATION 2200/part_ee_ff [insert] LOG: CREATING RELATION 2200/part_ee_ff1 [insert] LOG: CREATING RELATION 2200/part_ee_ff2 [insert] LOG: CREATING RELATION 2200/part_ee_ff3 [insert] LOG: CREATING RELATION 2200/part_ee_ff3_1 [insert] LOG: CREATING RELATION 2200/part_ee_ff3_2 [inherit] LOG: CREATING RELATION 2200/part_ef_gh [create_table] LOG: CREATING RELATION 2200/part_forced_oids [insert] LOG: CREATING RELATION 2200/part_gg [insert] LOG: CREATING RELATION 2200/part_gg1 [insert] LOG: CREATING RELATION 2200/part_gg2 [insert] LOG: CREATING RELATION 2200/part_gg2_1 [insert] LOG: CREATING RELATION 2200/part_gg2_2 [create_table] LOG: CREATING RELATION 2200/part_null [insert] LOG: CREATING RELATION 2200/part_null [inherit] LOG: CREATING RELATION 2200/part_null_xy [create_table] LOG: CREATING RELATION 2200/part_null_z [alter_table] LOG: CREATING RELATION 2200/part_rp [insert] LOG: CREATING RELATION 2200/part_xx_yy [insert] LOG: CREATING RELATION 2200/part_xx_yy_defpart [insert] LOG: CREATING RELATION 2200/part_xx_yy_p1 [create_table] LOG: CREATING RELATION 2200/parted [triggers] LOG: CREATING RELATION 2200/parted2_stmt_trig [triggers] LOG: CREATING RELATION 2200/parted2_stmt_trig1 [triggers] LOG: CREATING RELATION 2200/parted2_stmt_trig2 [create_table] LOG: CREATING RELATION 2200/parted_col_comment [insert_conflict] LOG: CREATING RELATION 2200/parted_conflict_test [insert_conflict] LOG: CREATING RELATION 2200/parted_conflict_test_1 [insert_conflict] LOG: CREATING RELATION 2200/parted_conflict_test_1_b_key [inherit] LOG: CREATING RELATION 2200/parted_minmax [inherit] LOG: CREATING RELATION 2200/parted_minmax1 [inherit] LOG: CREATING RELATION 2200/parted_minmax1i [alter_table] LOG: CREATING RELATION 2200/parted_no_parts [tablesample] LOG: CREATING RELATION 2200/parted_sample [tablesample] LOG: CREATING RELATION 2200/parted_sample_1 [tablesample] LOG: CREATING RELATION 2200/parted_sample_2 [triggers] LOG: CREATING RELATION 2200/parted_stmt_trig [triggers] LOG: CREATING RELATION 2200/parted_stmt_trig1 [triggers] LOG: CREATING RELATION 2200/parted_stmt_trig2 [inherit] LOG: CREATING RELATION 2200/parted_tab [inherit] LOG: CREATING RELATION 2200/parted_tab_part1 [inherit] LOG: CREATING RELATION 2200/parted_tab_part2 [inherit] LOG: CREATING RELATION 2200/parted_tab_part3 [rules] LOG: CREATING RELATION 2200/parted_table [rules] LOG: CREATING RELATION 2200/parted_table_1 [alter_table] LOG: CREATING RELATION 2200/parted_validate_test [alter_table] LOG: CREATING RELATION 2200/parted_validate_test_1 [insert_conflict] LOG: CREATING RELATION 2200/partial_key_index [alter_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned [create_table] LOG: CREATING RELATION 2200/partitioned2 [plpgsql] LOG: CREATING RELATION 2200/partitioned_table [updatable_views] LOG: CREATING RELATION 2200/pt [foreign_data] LOG: CREATING RELATION 2200/pt1 [join] LOG: CREATING RELATION 2200/pt1 [updatable_views] LOG: CREATING RELATION 2200/pt1 [updatable_views] LOG: CREATING RELATION 2200/pt11 [join] LOG: CREATING RELATION 2200/pt1p1 [join] LOG: CREATING RELATION 2200/pt1p1p1 [join] LOG: CREATING RELATION 2200/pt1p2 [foreign_data] LOG: CREATING RELATION 2200/pt2 [foreign_data] LOG: CREATING RELATION 2200/pt2_1 [foreign_data] LOG: CREATING RELATION 2200/pt2_1 [foreign_data] LOG: CREATING RELATION 2200/pt2_1 [plpgsql] LOG: CREATING RELATION 2200/pt_part1 [plpgsql] LOG: CREATING RELATION 2200/pt_part2 [inherit] LOG: CREATING RELATION 2200/range_list_parted [alter_table] LOG: CREATING RELATION 2200/range_parted [create_table] LOG: CREATING RELATION 2200/range_parted [insert] LOG: CREATING RELATION 2200/range_parted [update] LOG: CREATING RELATION 2200/range_parted [alter_table] LOG: CREATING RELATION 2200/range_parted2 [create_table] LOG: CREATING RELATION 2200/range_parted2 [create_table] LOG: CREATING RELATION 2200/range_parted3 [create_table] LOG: CREATING RELATION 2200/range_parted4 [create_table] LOG: CREATING RELATION 2200/range_parted4_1 [create_table] LOG: CREATING RELATION 2200/range_parted4_2 [create_table] LOG: CREATING RELATION 2200/range_parted4_3 [sequence] LOG: CREATING RELATION 2200/seq [updatable_views] LOG: CREATING RELATION 2200/seq [sequence] LOG: CREATING RELATION 2200/seq2 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [sequence] LOG: CREATING RELATION 2200/seq3 [join] LOG: CREATING RELATION 2200/t1 [privileges] LOG: CREATING RELATION 2200/t1 [updatable_views] LOG: CREATING RELATION 2200/t1 [updatable_views] LOG: CREATING RELATION 2200/t1 [updatable_views] LOG: CREATING RELATION 2200/t1 [updatable_views] LOG: CREATING RELATION 2200/t11 [updatable_views] LOG: CREATING RELATION 2200/t111 [updatable_views] LOG: CREATING RELATION 2200/t111_a_idx [updatable_views] LOG: CREATING RELATION 2200/t11_a_idx [updatable_views] LOG: CREATING RELATION 2200/t12 [updatable_views] LOG: CREATING RELATION 2200/t12_a_idx [updatable_views] LOG: CREATING RELATION 2200/t1_a_idx [privileges] LOG: CREATING RELATION 2200/t1_pkey [join] LOG: CREATING RELATION 2200/t2 [updatable_views] LOG: CREATING RELATION 2200/t2 [join] LOG: CREATING RELATION 2200/t3 [alter_table] LOG: CREATING RELATION 2200/tab1 [alter_table] LOG: CREATING RELATION 2200/tab2 [triggers] LOG: CREATING RELATION 2200/table1 [triggers] LOG: CREATING RELATION 2200/table2 [alter_table] LOG: CREATING RELATION 2200/test [with] LOG: CREATING RELATION 2200/test [alter_table] LOG: CREATING RELATION 2200/test1 [copyselect] LOG: CREATING RELATION 2200/test1 [privileges] LOG: CREATING RELATION 2200/test10b [privileges] LOG: CREATING RELATION 2200/test11b [copyselect] LOG: CREATING RELATION 2200/test1_id_seq [alter_table] LOG: CREATING RELATION 2200/test2 [copyselect] LOG: CREATING RELATION 2200/test2 [copyselect] LOG: CREATING RELATION 2200/test2_id_seq [copyselect] LOG: CREATING RELATION 2200/test3 [privileges] LOG: CREATING RELATION 2200/test5b [privileges] LOG: CREATING RELATION 2200/test6b [privileges] LOG: CREATING RELATION 2200/test7b [privileges] LOG: CREATING RELATION 2200/test8a [privileges] LOG: CREATING RELATION 2200/test8b [privileges] LOG: CREATING RELATION 2200/test9a [privileges] LOG: CREATING RELATION 2200/test9b [rules] LOG: CREATING RELATION 2200/test_1 [rules] LOG: CREATING RELATION 2200/test_1_pkey [rules] LOG: CREATING RELATION 2200/test_2 [rules] LOG: CREATING RELATION 2200/test_2_pkey [rules] LOG: CREATING RELATION 2200/test_3 [rules] LOG: CREATING RELATION 2200/test_3_pkey [alter_table] LOG: CREATING RELATION 2200/test_add_column [inherit] LOG: CREATING RELATION 2200/test_constraints [inherit] LOG: CREATING RELATION 2200/test_constraints_inh [inherit] LOG: CREATING RELATION 2200/test_constraints_val1_va= l2_key [alter_table] LOG: CREATING RELATION 2200/test_drop_constr_chi= ld [alter_table] LOG: CREATING RELATION 2200/test_drop_constr_par= ent [inherit] LOG: CREATING RELATION 2200/test_ex_constraints [inherit] LOG: CREATING RELATION 2200/test_ex_constraints_c_ex= cl [inherit] LOG: CREATING RELATION 2200/test_ex_constraints_inh [drop_if_exists] LOG: CREATING RELATION 2200/test_exists [inherit] LOG: CREATING RELATION 2200/test_foreign_constraints [inherit] LOG: CREATING RELATION 2200/test_foreign_constraints= _inh [select_having] LOG: CREATING RELATION 2200/test_having [drop_if_exists] LOG: CREATING RELATION 2200/test_index_exists [alter_table] LOG: CREATING RELATION 2200/test_inh_check [alter_table] LOG: CREATING RELATION 2200/test_inh_check_child [create_table_like] LOG: CREATING RELATION 2200/test_like_id_1 [create_table_like] LOG: CREATING RELATION 2200/test_like_id_1= _a_seq [create_table_like] LOG: CREATING RELATION 2200/test_like_id_2 [create_table_like] LOG: CREATING RELATION 2200/test_like_id_3 [create_table_like] LOG: CREATING RELATION 2200/test_like_id_3= _a_seq [select_implicit] LOG: CREATING RELATION 2200/test_missing_tar= get [select_implicit] LOG: CREATING RELATION 2200/test_missing_tar= get2 [select_implicit] LOG: CREATING RELATION 2200/test_missing_tar= get3 [inherit] LOG: CREATING RELATION 2200/test_primary_constraints [inherit] LOG: CREATING RELATION 2200/test_primary_constraints= _pkey [rangetypes] LOG: CREATING RELATION 2200/test_range_elem [rangetypes] LOG: CREATING RELATION 2200/test_range_elem_idx [rangetypes] LOG: CREATING RELATION 2200/test_range_excl [rangetypes] LOG: CREATING RELATION 2200/test_range_excl_room_= during_excl [rangetypes] LOG: CREATING RELATION 2200/test_range_excl_speak= er_during_excl [rangetypes] LOG: CREATING RELATION 2200/test_range_gist [rangetypes] LOG: CREATING RELATION 2200/test_range_gist_idx [rangetypes] LOG: CREATING RELATION 2200/test_range_gist_idx [rangetypes] LOG: CREATING RELATION 2200/test_range_spgist [rangetypes] LOG: CREATING RELATION 2200/test_range_spgist_idx [rangetypes] LOG: CREATING RELATION 2200/test_range_spgist_idx [sequence] LOG: CREATING RELATION 2200/test_seq1 [alter_table] LOG: CREATING RELATION 2200/test_storage [tablesample] LOG: CREATING RELATION 2200/test_tablesample [tablesample] LOG: CREATING RELATION 2200/test_tablesample_v1 [tablesample] LOG: CREATING RELATION 2200/test_tablesample_v2 [alter_table] LOG: CREATING RELATION 2200/test_tbl1 [alter_table] LOG: CREATING RELATION 2200/test_tbl2 [alter_table] LOG: CREATING RELATION 2200/test_tbl2_subclass [alter_table] LOG: CREATING RELATION 2200/test_tbl3 [alter_table] LOG: CREATING RELATION 2200/test_tblx [tsearch] LOG: CREATING RELATION 2200/test_tsquery [create_table] LOG: CREATING RELATION 2200/test_tsvector [alter_table] LOG: CREATING RELATION 2200/test_type [alter_table] LOG: CREATING RELATION 2200/test_type1 [alter_table] LOG: CREATING RELATION 2200/test_type2 [alter_table] LOG: CREATING RELATION 2200/test_type3 [alter_table] LOG: CREATING RELATION 2200/test_type_diff [alter_table] LOG: CREATING RELATION 2200/test_type_diff2 [alter_table] LOG: CREATING RELATION 2200/test_type_diff2_c1 [alter_table] LOG: CREATING RELATION 2200/test_type_diff2_c2 [alter_table] LOG: CREATING RELATION 2200/test_type_diff2_c3 [alter_table] LOG: CREATING RELATION 2200/test_type_diff_c [alter_table] LOG: CREATING RELATION 2200/test_type_empty [drop_if_exists] LOG: CREATING RELATION 2200/test_type_exists [alter_table] LOG: CREATING RELATION 2200/test_typex [drop_if_exists] LOG: CREATING RELATION 2200/test_view_exists [combocid] LOG: CREATING RELATION 2200/testcase [combocid] LOG: CREATING RELATION 2200/testcase_pkey [create_table] LOG: CREATING RELATION 2200/testjsonb [insert_conflict] LOG: CREATING RELATION 2200/testoids [insert_conflict] LOG: CREATING RELATION 2200/testoids_pkey [publication] LOG: CREATING RELATION 2200/testpub_parted [publication] LOG: CREATING RELATION 2200/testpub_tbl1 [publication] LOG: CREATING RELATION 2200/testpub_tbl1_id_seq [publication] LOG: CREATING RELATION 2200/testpub_tbl1_pkey [publication] LOG: CREATING RELATION 2200/testpub_tbl2 [publication] LOG: CREATING RELATION 2200/testpub_tbl2_id_seq [publication] LOG: CREATING RELATION 2200/testpub_tbl2_pkey [publication] LOG: CREATING RELATION 2200/testpub_tbl3 [publication] LOG: CREATING RELATION 2200/testpub_tbl3a [publication] LOG: CREATING RELATION 2200/testpub_view [rolenames] LOG: CREATING RELATION 2200/testtab1 [rolenames] LOG: CREATING RELATION 2200/testtab2 [rolenames] LOG: CREATING RELATION 2200/testtab3 [rolenames] LOG: CREATING RELATION 2200/testtab4 [rolenames] LOG: CREATING RELATION 2200/testtab5 [rolenames] LOG: CREATING RELATION 2200/testtab6 [privileges] LOG: CREATING RELATION 2200/testtype1 [rowtypes] LOG: CREATING RELATION 2200/testtype1 [rowtypes] LOG: CREATING RELATION 2200/testtype1 [rowtypes] LOG: CREATING RELATION 2200/testtype2 [rowtypes] LOG: CREATING RELATION 2200/testtype3 [rowtypes] LOG: CREATING RELATION 2200/testtype3 [rowtypes] LOG: CREATING RELATION 2200/testtype4 [rowtypes] LOG: CREATING RELATION 2200/testtype5 [rowtypes] LOG: CREATING RELATION 2200/testtype5 [rowtypes] LOG: CREATING RELATION 2200/testtype6 [rowtypes] LOG: CREATING RELATION 2200/testtype6 [alter_table] LOG: CREATING RELATION 2200/tmp [alter_table] LOG: CREATING RELATION 2200/tmp [alter_table] LOG: CREATING RELATION 2200/tmp [alter_table] LOG: CREATING RELATION 2200/tmp [constraints] LOG: CREATING RELATION 2200/tmp [select] LOG: CREATING RELATION 2200/tmp [select_into] LOG: CREATING RELATION 2200/tmp1 [select_into] LOG: CREATING RELATION 2200/tmp1 [alter_table] LOG: CREATING RELATION 2200/tmp2 [alter_table] LOG: CREATING RELATION 2200/tmp2_pkey [alter_table] LOG: CREATING RELATION 2200/tmp3 [alter_table] LOG: CREATING RELATION 2200/tmp4 [alter_table] LOG: CREATING RELATION 2200/tmp4_a_b_key [alter_table] LOG: CREATING RELATION 2200/tmp5 [alter_table] LOG: CREATING RELATION 2200/tmp6 [alter_table] LOG: CREATING RELATION 2200/tmp7 [alter_table] LOG: CREATING RELATION 2200/tmp_array [alter_table] LOG: CREATING RELATION 2200/tmp_array [alter_table] LOG: CREATING RELATION 2200/tmp_array2 [alter_table] LOG: CREATING RELATION 2200/tmp_idx [alter_table] LOG: CREATING RELATION 2200/tmp_view [indirect_toast] LOG: CREATING RELATION 2200/toasttest [strings] LOG: CREATING RELATION 2200/toasttest [strings] LOG: CREATING RELATION 2200/toasttest [strings] LOG: CREATING RELATION 2200/toasttest [alter_table] LOG: CREATING RELATION 2200/unlogged1 [create_table] LOG: CREATING RELATION 2200/unlogged1 [alter_table] LOG: CREATING RELATION 2200/unlogged1_f1_seq [alter_table] LOG: CREATING RELATION 2200/unlogged1_pkey [create_table] LOG: CREATING RELATION 2200/unlogged1_pkey [alter_table] LOG: CREATING RELATION 2200/unlogged2 [create_table] LOG: CREATING RELATION 2200/unlogged2 [alter_table] LOG: CREATING RELATION 2200/unlogged2_f1_seq [alter_table] LOG: CREATING RELATION 2200/unlogged2_pkey [create_table] LOG: CREATING RELATION 2200/unlogged2_pkey [alter_table] LOG: CREATING RELATION 2200/unlogged3 [alter_table] LOG: CREATING RELATION 2200/unlogged3_f1_seq [alter_table] LOG: CREATING RELATION 2200/unlogged3_pkey [create_index] LOG: CREATING RELATION 2200/unlogged_hash_index [create_index] LOG: CREATING RELATION 2200/unlogged_hash_table [alter_table] LOG: CREATING RELATION 2200/unparted [create_table] LOG: CREATING RELATION 2200/unparted [alter_table] LOG: CREATING RELATION 2200/xxx [with] LOG: CREATING RELATION 2200/z [with] LOG: CREATING RELATION 2200/z_k_key [alter_generic] LOG: CREATING ROLE regress_alter_user1 [alter_table] LOG: CREATING ROLE regress_alter_user1 [alter_generic] LOG: CREATING ROLE regress_alter_user2 [alter_generic] LOG: CREATING ROLE regress_alter_user3 [alter_generic] LOG: CREATING ROLE regress_alter_user5 [alter_generic] LOG: CREATING ROLE regress_alter_user6 [create_procedure] LOG: CREATING ROLE regress_user1 [identity] LOG: CREATING ROLE regress_user1 [privileges] LOG: CREATING ROLE regress_user1 [privileges] LOG: CREATING ROLE regress_user2 [privileges] LOG: CREATING ROLE regress_user3 [privileges] LOG: CREATING ROLE regress_user4 [privileges] LOG: CREATING ROLE regress_user5 [rolenames] LOG: CREATING ROLE session_user [insert] LOG: CREATING ROLE someone_else [rolenames] LOG: CREATING ROLE user [create_view] LOG: CREATING SCHEMA test_schema [rolenames] LOG: CREATING SCHEMA test_schema [namespace] LOG: CREATING SCHEMA test_schema_1 Some of these test pairs have enough conflicts that it may not be worth the work to eliminate them. Not sure just what to change here. regards, tom lane ------- =_aaaaaaaaaa0 Content-Type: text/x-diff; name="quick-hack-log-names-used.patch"; charset="us-ascii" Content-ID: <16511.1521080854.2@sss.pgh.pa.us> Content-Description: quick-hack-log-names-used.patch Content-Transfer-Encoding: quoted-printable diff --git a/src/backend/catalog/heap.c b/src/backend/catalog/heap.c index 3d80ff9..59b37fe 100644 *** a/src/backend/catalog/heap.c --- b/src/backend/catalog/heap.c *************** *** 40,45 **** --- 40,46 ---- #include "catalog/dependency.h" #include "catalog/heap.h" #include "catalog/index.h" + #include "catalog/namespace.h" #include "catalog/objectaccess.h" #include "catalog/partition.h" #include "catalog/pg_attrdef.h" *************** InsertPgClassTuple(Relation pg_class_des *** 828,833 **** --- 829,838 ---- */ HeapTupleSetOid(tup, new_rel_oid); = + if (!isTempNamespace(rd_rel->relnamespace)) + elog(LOG, "CREATING RELATION %u/%s", + rd_rel->relnamespace, RelationGetRelationName(new_rel_desc)); + = /* finally insert the new tuple, update the indexes, and clean up */ CatalogTupleInsert(pg_class_desc, tup); = diff --git a/src/backend/catalog/pg_namespace.c b/src/backend/catalog/pg_n= amespace.c index 2cf52be..a331b9c 100644 *** a/src/backend/catalog/pg_namespace.c --- b/src/backend/catalog/pg_namespace.c *************** NamespaceCreate(const char *nspName, Oid *** 87,92 **** --- 87,94 ---- = tup =3D heap_form_tuple(tupDesc, values, nulls); = + elog(LOG, "CREATING SCHEMA %s", nspName); + = nspoid =3D CatalogTupleInsert(nspdesc, tup); Assert(OidIsValid(nspoid)); = diff --git a/src/backend/catalog/pg_proc.c b/src/backend/catalog/pg_proc.c index 466ff03..42b1a2f 100644 *** a/src/backend/catalog/pg_proc.c --- b/src/backend/catalog/pg_proc.c *************** *** 18,23 **** --- 18,24 ---- #include "access/xact.h" #include "catalog/dependency.h" #include "catalog/indexing.h" + #include "catalog/namespace.h" #include "catalog/objectaccess.h" #include "catalog/pg_language.h" #include "catalog/pg_namespace.h" *************** ProcedureCreate(const char *procedureNam *** 576,581 **** --- 577,587 ---- nulls[Anum_pg_proc_proacl - 1] =3D true; = tup =3D heap_form_tuple(tupDesc, values, nulls); + = + if (!isTempNamespace(procNamespace)) + elog(LOG, "CREATING FUNCTION %u/%s", + procNamespace, procedureName); + = CatalogTupleInsert(rel, tup); is_update =3D false; } diff --git a/src/backend/commands/user.c b/src/backend/commands/user.c index 71c5caa..b66a933 100644 *** a/src/backend/commands/user.c --- b/src/backend/commands/user.c *************** CreateRole(ParseState *pstate, CreateRol *** 440,445 **** --- 440,447 ---- binary_upgrade_next_pg_authid_oid =3D InvalidOid; } = + elog(LOG, "CREATING ROLE %s", stmt->role); + = /* * Insert new record in the pg_authid table */ ------- =_aaaaaaaaaa0--