Chapter 31. Regression Tests

   Table of Contents

   31.1. Running the Tests

        31.1.1. Running the Tests Against a Temporary Installation
        31.1.2. Running the Tests Against an Existing Installation
        31.1.3. Additional Test Suites
        31.1.4. Locale and Encoding
        31.1.5. Custom Server Settings
        31.1.6. Extra Tests

   31.2. Test Evaluation

        31.2.1. Error Message Differences
        31.2.2. Locale Differences
        31.2.3. Date and Time Differences
        31.2.4. Floating-Point Differences
        31.2.5. Row Ordering Differences
        31.2.6. Insufficient Stack Depth
        31.2.7. The “random” Test
        31.2.8. Configuration Parameters

   31.3. Variant Comparison Files
   31.4. TAP Tests

        31.4.1. Environment Variables

   31.5. Test Coverage Examination

        31.5.1. Coverage with Autoconf and Make
        31.5.2. Coverage with Meson

   The regression tests are a comprehensive set of tests for the SQL
   implementation in PostgreSQL. They test standard SQL operations as well
   as the extended capabilities of PostgreSQL.