pgTAP

pgTap is written in PL/pgSQL and PL/SQL, following the xUnit philosophy, responsible for frameworks like NUnit, JUnit and more.

The framework is basically a collection of various functions for gathering, analyzing and reporting on PostgreSQL-powered applications.

pgTap allows developers to test their PostgreSQL code works as intended and does not block, crash or misbehaves in any way.

What is new in this release:

• Fixed misselling of "constraint" in constraint test diagnostic output.
• Fixed constraint, trigger, index, opclaass, and foreign key test functions so that they don't find objects outside the search path unless the schema is specified.
• Fixed `col_type_is()` so that it won't report the column as not existing when the column's data type is not in the search path.
• Removed `format_type()` and switched to the core PostgreSQL type formatting function so that type names always include the schema name if the schema is not in the search path. You might have to update data type tests to include the schema name if the type is not in the search path.
• `ALTER EXTENSION` now properly updates the value returned by `pgtap_version()`.

Requirements:

• PostgreSQL 8.1 or higher