On the recordRead 3 Oct 202618 facts
pgTAP
On the record
- Database behavior
- Tests can exercise database views, procedures, functions, rules, and triggers.pgtap.org · read 2 Oct 2026
- Database requirement
- The package documentation says pgTAP requires PostgreSQL 9.1 or higher.pgxn.org · read 3 Oct 2026
- Database testing
- Its assertion functions can test database values and exercise views, procedures, functions, rules, and triggers.pgtap.org · read 3 Oct 2026
- Hosting requirement
- pgTAP must be installed on a host with PostgreSQL running and cannot be installed remotely.pgxn.org · read 3 Oct 2026
- Installation
- pgTAP must be installed on a host running PostgreSQL and cannot be installed remotely.pgxn.org · read 2 Oct 2026
- Integration guidance
- The integration page mentions PHP and Python testing frameworks but says users should send instructions for those integrations to the project's mailing list.pgtap.org · read 3 Oct 2026
- Integrations
- The integration guide describes running pgTAP tests with Perl's Test::Harness and TAP::Harness, and with PostgreSQL module testing tools.pgtap.org · read 3 Oct 2026
- Latest listed release
- PGXN lists pgTAP 1.3.4 as the stable release, dated 2025-10-04.pgxn.org · read 3 Oct 2026
- License
- The PGXN package page grants permission to use, copy, modify, and distribute pgTAP and its documentation without a fee, subject to the stated conditions.pgxn.org · read 3 Oct 2026
- PostgreSQL requirement
- The release page says pgTAP requires PostgreSQL 9.1 or higher.pgxn.org · read 2 Oct 2026
- Purpose
- pgTAP is a PostgreSQL unit testing framework that emits TAP from psql scripts or xUnit style test functions.pgtap.org · read 3 Oct 2026
- Schema testing
- The framework includes functions for checking schema objects such as tables, columns, and primary keys.pgtap.org · read 3 Oct 2026
- Support
- The license says the author has no obligation to provide maintenance, support, updates, enhancements, or modifications.pgxn.org · read 2 Oct 2026
- Support terms
- The package license disclaims any obligation to provide maintenance, support, updates, enhancements, or modifications.pgxn.org · read 3 Oct 2026
- Test isolation
- The xUnit-style runtests() function rolls back changes made to the schema during each test and supports setup, teardown, startup, and shutdown functions.pgtap.org · read 2 Oct 2026
- Test output
- pgTAP emits TAP output that can be collected and reported by a TAP harness.pgtap.org · read 2 Oct 2026
- Test runner
- pg_prove can run pgTAP tests and display TAP results.pgtap.org · read 3 Oct 2026
- Test styles
- pgTAP supports both scripting style tests and xUnit style tests, including setup and teardown functions for xUnit tests.pgtap.org · read 3 Oct 2026