On Fri, Jan 31, 2014 at 6:09 AM, Robert Haas <robertmh...@gmail.com> wrote:
> On Thu, Jan 30, 2014 at 3:32 AM, Christian Kruse
> <christ...@2ndquadrant.com> wrote:
>>> For the documentation patch, I propose the attached to avoid future
>>> confusions. Comments? It might make sense to back-patch as well.
>>
>> Compiles, didn't find any typos and I think it is comprehensible.
>
> I took a look at this with a view to committing it but on examination
> I'm not sure this is the best way to proceed.  The proposed text
> documents that the tests should be run in a database called
> regression, but the larger documentation chapter of which this section
> is a part never explains how to run them anywhere else, so it feels a
> bit like telling a ten-year-old not to burn out the clutch.
>
> The bit about not changing enable_* probably belongs, if anywhere, in
> section 30.2, on test evaluation, rather than here.
And what about the attached? I have moved all the content to 30.2, and
added two paragraphs: one about the planner flags, the other about the
database used.
Regards,
-- 
Michael
*** a/doc/src/sgml/regress.sgml
--- b/doc/src/sgml/regress.sgml
***************
*** 471,476 **** diff results/random.out expected/random.out
--- 471,510 ----
       not worry unless the random test fails repeatedly.
      </para>
     </sect2>
+ 
+    <sect2>
+     <title>Planner Configuration parameters</title>
+ 
+     <para>
+      Parameters able to change the planning of queries like enable/disable
+      flags described in <xref linkend="runtime-config-query-enable"> for
+      <command>EXPLAIN</> should use default values.
+     </para>
+    </sect2>
+ 
+    <sect2>
+     <title>Database Name</title>
+ 
+     <para>
+      Regression tests should be run on a database named <literal>regression</>
+      to prevent failures of tests using directly or indirectly the current
+      database name in output results. The tests that would fail in this case
+      include <literal>updatable_views</literal>, <literal>foreign_data</literal>,
+      <literal>xml_map</literal> and <literal>sequence</literal>.
+     </para>
+ 
+     <para>
+      <literal>regression</> is the default database name for tests of core,
+      and contrib modules use <literal>contrib_regression</> as default.
+     </para>
+ 
+     <para>
+      Running regression tests with <application>pg_regress</application>
+      causes the existed database to be dropped before running the tests,
+      so be sure that there is not already a database with the same name
+      existing on server before running it.
+     </para>
+    </sect2>
    </sect1>
  
  <!-- We might want to move the following section into the developer's guide. -->
-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to