Changes

Revision history for pgTAP
==========================

0.93.0
---------------------------
* Added `schema_owner_is()`. Not sure how I overlooked adding it in v0.92.0.
* Fixed misselling of "constraint" in constraint test diagnostic output.
* Fixed `fk_ok()` so that the table must be visible in the search path when
  the schema name is not specified.
* Fixed constraint- and trigger-checking functions so that they only look at
  tables visible in the search path unles the schema is specified.

0.92.0 2013-01-16T00:41:07Z
---------------------------
* Fixed some misspellings of `SELECT` in documentation examples.
* Added note about the lack of typemods to the documentation for `has_cast()`.
* Added check to ensure a table is visible in tests for column defaults.
  Thanks to Henk Enting for the report.
* Added `has_relation()` and `hasnt_relation()`.
* Added `has_foreign_table()` and `hasnt_foreign_table()`.
* Added `has_composite()` and `hasnt_composite()`.
* Added new ownership assertion functions:
  + `relation_owner_is()`
  + `table_owner_is()`
  + `view_owner_is()`
  + `sequence_owner_is()`
  + `composite_owner_is()`
  + `foreign_table_owner_is()`
  + `function_owner_is()`
* Changed the uninformative error 'relation "__tcache__" does not exist' to
  the more useful 'You tried to run a test without a plan! Gotta have a plan'.
  Thanks to Steven Samuel Cole for [the
  report](https://github.com/theory/pgtap/issues/22).
* Changed `triggers_are()` so that it ignores internal triggers on PostgreSQL
  9.1 and higher. Thanks to Sherrylyn Branchaw for the report!
* Changed the diagnostic output of `results_eq()` for data type differences to
  reduce confusion when the rows have the same values of different types.
  Thanks to Peter Eisentraut and Taylor Ralston for [the
  nudging](https://github.com/theory/pgtap/issues/15).
* Added `isnt_empty()` to ensure that a query does not return the empty set.
* Fixed `has_index()` to properly handle indexes composed of both columns and
  expressions.
* Added new functions for testing a user's access to database objects:
  + `database_privs_are()`
  + `tablespace_privs_are()`
  + `schema_privs_are()`
  + `table_privs_are()`
  + `sequence_privs_are()`
  + `any_column_privs_are()`
  + `column_privs_are()`
  + `function_privs_are()`
  + `language_privs_are()`
  + `fdw_privs_are()`
  + `server_privs_are()`

0.91.1 2012-09-11T00:26:52Z
---------------------------
* The OS name is restored to the call to `os_name()`. The `getos.sh` shell
  script was not getting called during `make`. Thanks to Peter Eisentraut for
  [the report](https://github.com/theory/pgtap/issues/16).
* Noted `pg_prove --verbose` for showing test descriptions and fixed a few
  typos in the documentation. Thanks to Jay Levitt for the pull request!
* Fixed broken examples in the `row_eq()` documentation. Thanks to @set5think
  for the report!
* Fixed `has_tablespace()` to work on PostgreSQL 9.2, where its failure was
  preventing pgTAP from even being installed.

0.90.0 2011-12-03T20:18:16Z
---------------------------
* Removed the "Supported Versions" section of the documentation. Suffice it to
  say that pgTAP supports PostgreSQL 8.0 or higher.
* Added a build target to create a portable copy of pgTAP that can be included
  in any distribution and should just work for tesing on PostgreSQL 8.3+. The
  new files are `pgtap-core.sql`, which contains the core functionality, and
  `pgtap-schema.sql`, which depends on pgtap-core and adds in the schema
  testing assertion functions.
* Added abstract to the `provides` section of `META.json`.
* Removed use of `relistemp` column in an internal function, as it has been
  removed in PostgreSQL 9.1. As a bonus, it now works on PostgreSQL 8.3 and
  older without needing to be patched. Thanks to Tom Lane for the alternate
  syntax.
* Added PostreSQL 9.1 `CREATE EXTENSION` support.
* Removed `TAPSCHEMA` option to `make`. Use `PGOPTIONS=--search_path=tap` with
  `psql`, instead.
* Added `db_owner_is()`. Based on a patch by Gerd Koenig.
* Dropped support for PostgreSQL 8.0, as the new directory structure
  introduced in 0.25.0 is incompatible with the 8.0 version og `pg_regress`,
  making testing all but impossible. 8.0 has been EOLed for some time, so it's
  time for pgTAP to finally drop its support, too.

0.25.0 2011-02-02T03:21:55Z
---------------------------
* Minor documentation tweaks.
* The sequence created to keep track of test numbers is now a temporary
  sequence. This will prevent it from persisting beyond the current
  connection, which could lead to erorrs in future connections. Thanks to
  Richard Huxton for the report.
* Fixed `is_superuser()` and `isnt_superuser()` so that they properly detect
  superuser roles as well as users.
* Fixed examples of single-quoted string values stored in `psql` variables in
  `README.pgtap`.
* Fixed a bug in `plan()` where a sequence wasn't getting created as a
  temporary sequence. This wasn't a problem if all testing was done inside a
  transaction, but if not, you could only run tests once without an error.
* Fixed bug where `has_column()`, `col_type_is()`, `domain_type_is()`,
  `cast_exists()`, `cast_context_is()`, and `has_operator()`, were forcing the
  type argument to lowercase, which wasn't correct when the type is actually
  mixed case or uppercase (that is, named in double quotes when it was
  created).
* The expected type passed to `index_is_type()` is no longer compared
  case-insensitively, since it might be possible in the future to create a
  type with mixed case by using double quotes when naming it.
* Documented that double-quotes must be used for types created with
  double-quoted names in the strings passed to `casts_are()`. This should be
  the only part of the API that does require this sort of quoting.
* Added `diag(anyelement)` (for 8.3 and higher) and `diag(VARIADIC anyarray)`
  (for 8.4 and higher) to make it easier to emit diagnostics for whatever data
  you have at hand.
* The `_cleanup()` function now properly drops the temporary sequences as well
  as the temporary tables. These are usually automatically dropped when the
  tests finish and the client disconnects, but it's best to try to keep things
  tidy ourselves, too. Spotted by Peter Eisentraut.
* Fixed a bug in `has_pk()` so that it properly checks that a table is visible
  in the search path when a schema is not specified, and doesn't check that
  when the schema *is* specified. Patch from Cédric Villemain.
* Fixed a bug in `col_is_unique()` and `col_has_check()` where they considered
  *all* columns in a table that were unique or involved in a check constraint
  were assocated with only one constraint. Since one can have multiple unique
  or check constraints on a table, each using different columns, this was
  sub-optimal. Thanks to Cédric Villemain for the spot!
* Removed `pg_prove` and `pg_tapgen` from the distribution. They must now be
  installed separately from CPAN. If it's not installed, the intaller will
  issue a warning.
* Added `META.json` and distributed on [PGXN](http://pgxn.org/).
* Rearranged the source directory layout to more closely match the [preferred
  PGXN layout](http://manager.pgxn.org/howto#new-order).

0.24 2010-05-24T23:33:22Z
--------------------------
* Got `sql/artap.sql` tests passing again when building with `$TAPSCHEMA` set.
* Changed to saner source URL in `contrib/pgtap.spec`.
* Fixed a bug in `has_member()` where it failed to confirm that users were
  actually members of a group.
* Fixed a bug where `display_type()` would include the schema name in its
  output for types not found in the current path, despite its assertion that
  it wouldn't.
* Changed the diagnostic output for row type mismatches from `set_eq()`,
  `set_ne()`, `bag_eq()`, and `bag_ne()` to include the schema name for types
  not found in the search path.
* Fixed bug in the diagnostic output of `set_eq()`, `set_ne()`, `bag_eq()`,
  and `bag_ne()` where a column's type would not be displayed if the column
  was not in the search path. Thanks to Rod Taylor for the spot!
* Made the implementation of `row_eq()` always return a value, even if the
  query it executes returns no rows.
* Fixed bug in the default description for `col_type_is()` where the column
  name was listed as the type!
* Updated the `Makefile` and the test suite to support PostgreSQL 9.
* Removed the primary keys from the temporary tables used internally by pgTAP
  and thus eliminated the logging of NOTICEs to the PostgreSQL log when pgTAP
  creates those tables.
* Eliminated the need to set `USE_PGXS=1` when building outsde the contrib
  directory of the PostgreSQL distribution. If `pg_config` isn't in the
  `$PATH` environment variable, one can simply set `PG_CONFIG` to point to it.
  If building inside the contrib directory, set `NO_PGXS=1`.
* Fixed typo in the statement to drop the `tap_funky` view in
  `uninstall_pgtap.sql`. Thanks to Erik Rijkers.
* Removed deprecated `can_ok()` functions. Use `has_function()`, instead.

0.23 2009-12-18T23:03:39Z
-------------------------
* Fixed broken Perl detection in `Makefile`.
* Copied OS detection from Perl's `Configure` script to new script,
  `getos.sh`. OS detection should now be much more accurate.
* Fixed `pg_prove` to exit with non-zero status if tests failed, as it works
  better in automated testing environments and consistent with `prove` (fix by
  Darrell Fuhriman).
* Updated documentation of supported environment variables in `bin/pg_prove`.
* Fixed a bug in the function tests where the return value of a function was
  not always consistently formatted. For example, `function_returns()` would
  find "bool" instead of "boolean".
* Added `isa_ok()`.
* Added support for building against 8.5 [Dan Colish].
* Fixed failing test on alpha releases [Jonathan Leto]
* Added `is_empty()` to test that a query returns an empty set (no results).
* Added `collect_tap()`, which makes it easier to run multiple tests in a
  single `SELECT` statement in combination with `skip()`.
* Added `throws_like()`, `throws_ilike()`, `throws_matching()`, and
  `throws_imatching()` to test that an SQL statement throws an error message
  matching a `LIKE` pattern or a regular expression.
* Added `roles_are()`, `types_are()`, `domains_are()`, `enums_are()`,
  `triggers_are()`, `casts_are()`, `operators_are()`, and `columns_are()`.
* Fixed the diagnostic output from `isnt()` and `col_isnt_pk()` when they
  fail. They now more closely matches what Test::More's `isnt()` outputs and
  makes much more sense.
* Added `domain_type_is()` and `domain_type_isnt()`. Based on an
  implementation by Bob Lunney.
* Added variants of `col_is_type()` to allow a schema name to be specified for
  the type.
* Added `display_type()` and replaced all internal use of `format_type()` with
  it. This is so that schemas are always displayed properly.
* Added `row_eq()`. It's a 90% solution that requires that `record` values be
  cast to existing composite values. But it should work well even at that.
* Changed the default descriptions output by `has_operator()`, `has_leftop()`,
  and `has_rightop()` to format the operator names more like the display of
  `regoperator` types.
* Fixed issue with using SET SESSION AUTHORIZATION among tests [Kevin Field]
* Added `display_oper()` so that schemas are always displayed properly when
  comparing operators.

0.22 2009-07-31T00:26:16Z
-------------------------
* Fixed failing test on 8.4rc2.
* Added result set testing functions. These allow testers to write queries in
  pure SQL and check that their results are as expected. The new functions
  are:
  + `results_eq()`
  + `results_ne()`
  + `set_eq()`
  + `bag_eq()`
  + `set_ne()`
  + `bag_ne()`
  + `set_has()`
  + `bag_has()`
  + `set_hasnt()`
  + `bag_hasnt()`
* Changed some internal queries to use explicit `JOIN`s.
* Fixed capitalization of `TAP::Harness` in the `Makefile`. Thanks to
  Quinn Weaver.
* Fixed a syntax error that caused `uninstall_pgtap.sql` to fail on older
  PostgreSQL versions (fix by Quinn Weaver).
* Modified the summary documentation for the `--schema` and `--match` options
  to `pg_prove` to better reflect that they are for finding xUnit tests,
  not for finding pgTAP functions.

0.21 2009-05-29T00:04:31Z
-------------------------
* Fixed a bug in the processing of the `--schema` and `--match` options that
  only shows up in Getopt::Long 2.38 or higher.
* A few doc and test typos fixed thanks to Gabrielle Roth.
* Fixed failing test on Solaris 10 on Intel thanks to Gabrielle Roth.
* Fixed a failing test for the version number string on 8.4 beta.
* Added `performs_ok()`.
* Added `has_language()`, `hasnt_language()`, and `language_is_trusted()`.
* Added `has_opclass()` and `hasnt_opclass()`.
* Added `has_rule()`, `hasnt_rule()`, `rule_is_instead()`, and `rule_is_on()`.
* Added `tablespaces_are()`, `schemas_are()`, `tables_are()`, `views_are()`,
  `sequences_are()`, `functions_are()`, `indexes_are()`, `users_are()`,
  `groups_are()`, `opclasses_are()`, `languages_are()`, and `rules_are()`.
* Added a `has_trigger(table, trigger, description)`. Note that this means
  that if you were previously using `has_trigger(schema, table, trigger)`, you
  will need to cast the third argument to `NAME` to get it working again.
* Changed `can_ok()` to `has_function()`, so that it's named like all of the
  other functions that check for the presence of database objects. The old
  `can_ok()` function is still available as an alias, but it emits a warning
  and will be removed in a future version of pgTAP.
* Added `hasnt_trigger()`, `hasnt_index()`, and `hasnt_function()`.
* Added `function_lang_is()`, `function_returns()`, `is_definer()`,
  `is_aggregate()`, `is_strict()`, and `volatility_is()`.

0.20 2009-03-29T19:05:40Z
-------------------------
* Changed the names of the functions tested in `sql/do_tap.sql` and
  `sql/runtests.sql` so that they are less likely to be ordered differently
  given varying collation orders provided in different locales and by
  different vendors. Reported by Ingmar Brouns.
* Added the `--formatter` and `--archive` options to `pg_prove`.
* Fixed the typos in `pg_prove` where the output of `--help` listed
  `--test-match` and `--test-schema` instead of `--match` and `--schema`.
* Added `has_cast()`, `hasnt_cast()`, and `cast_context_is()`.
* Fixed a borked function signature in `has_trigger()`.
* Added `has_operator()`, `has_leftop()`, and `has_rightop()`.
* Fixed a bug where the order of columns found for multicolumn indexes by
  `has_index()` could be wrong. Reported by Jeff Wartes. Thanks to Andrew
  Gierth for help fixing the query.

0.19 2009-02-21T02:09:26Z
-------------------------
* Added an alternate version of `col_default_is()` to better handle the common
  case when a default is specified as a string, such as a text or expression
  default. This means that you have to do a lot less casting of default values
  specified in the arguments to `col_default_is()`. It also restores the
  signature that 0.17 recommended be dropped.
* Added `has_role()` and `isnt_role()`.
* Added `has_user()`, `isnt_user()`, `is_superuser()`, and `isnt_superuser()`.
* Added `has_group()`, `isnt_group()`, and `is_member_of()`.
* Fixed syntax in the `Makefile` to make it compatible with older versions of
  `make`. Reported by Aaron Kangas.
* Improved the documentation of `runtests()` to make it clearer that all tests
  it runs are run in transactions that are rolled back after each test.
  Suggested by Aaron Kangas.
* Added the `--runtests`, `--schema`, and `--match` options to `pg_prove` so
  that it can be used to run xUnit-style test functions without an SQL script.
* Fixed a bug in `can()` where it could sometimes report that functions
  were available in a schema when in fact they were not.
* In the schema testing functions, removed the use of `quote_ident()` to
  compare all identifiers, such as table names, schema names, column names,
  etc, added in 0.17. This is because `quote_ident(a) = quote_ident(b)` can't
  give a different result than `a = b`, and besides, made things slower and
  prevented the use of indexes. Thanks to Andrew Gierth for the spot.
* The output from `pg_prove` now includes a list of failing tests when it is
  not run with `--verbose`. When using TAP::Harness 3.17 and later, it also
  shows comments and diagnostics in the non-verbose output. Verbose output
  still outputs everything.

0.18  2009-02-06T20:06:00Z
--------------------------
* Fixed `pg_version_num()`. It was broken in 0.16; sorry about that!
* Fixed a bug in `col_type_is()` where it would die if it was looking
  for a type in a table that had dropped columns. Thanks to depesz and
  RhodiumToad on #postgresql for the help nailing that one down!
* Fixed a test failure in `sql/coltap.sql` on PostgreSQL 8.3.
* Fixed a bug in the `Makefile` where it did not properly point to
  `pg_config` when building from the `compat` directory in the
  PostgreSQL source tree.
* Fixed a bug in the `Makefile` where the `test_setup.sql` file, which
  is required for tests, was not always getting created.

0.17  2009-02-06T17:51:52Z
--------------------------
* Fixed `col_default_is()` so that it works properly in cases where the
  default value is `NULL`.
* Fixed `col_default_is()` to gracefully handle different data types,
  columns without defaults, and nonexistent columns.
* Fixed the three-argument form of `col_default_is()` to accept any data type
  for the default, not just text. *NOTE:* You must `DROP FUNCTION
  col_default_is ( NAME, NAME, TEXT );` if you have previous versions of this
  function installed, so as to eliminate the incompatible version.
* Added `col_has_default()` and `col_hasnt_default()`.
* Changed default descriptions for column testing functions to refer to
  the columns as the more SQL-standard `schema.table.column` instead of
  `schema.table(column)`.
* Modified all diagnostic messages and test descriptions that reference
  database objects to use `quote_ident()` to quote the names of those
  objects, rather than emitting them with or without double-quotes in an
  ad-hoc way as had hitherto been the case.
* Modified `col_not_null()`, `col_is_null()` and `col_type_is()` to emit
  diagnostics if they fail because the column in question does not
  exist.
* Added `has_tablespace()` and `hasnt_tablespace()`.
* Added `has_sequence()` and `hasnt_sequence()`.
* Changed `has_index()` so that expressions are compared case-
  sensitively.
* In the schema testing functions, now using `quote_ident()` to compare
  all identifiers, such as table names, schema names, column names, etc.
  It had been a mix of straight-forward string comparison, and
  case-insensitive matching. This means that tests should use only
  lowercase strings to specify object names, unless mixed case objects
  were created with double quote characters.
* Added version of `todo()` with the `why` and `how_many` arguments
  reversed, so that I don't have to remember a specific order.

0.16  2009-02-03T17:37:03Z
--------------------------
* Switched from a crazy trinary logic in `is()` and `isnt()` to the use
  of `IS NOT DISTINCT FROM` and `IS DISTINCT FROM`. Swiped from PGUnit.
* Fixed documentation for the short version of `--help` in `pg_prove`.
  It's `-H`, not `-h`.
* Fixed a bug in the makefile that prevented OS detection from working
  properly on many platforms (including Linux, and probably many
  others). This allows `os_name()` to actually work on those platforms.
* The definition of the `pg_typeof()` function is removed when
  installing on PostgreSQL 8.4 and no C code is compiled, since the only
  C code is for this function. This is because `pg_typeof()` is included
  with PostgreSQL 8.4.
* Added `has_schema()` and `hasnt_schema()`.
* Added `has_type()`, `hasnt_type()`, `has_domain()`, `hasnt_domain()`,
  `has_enum()`, and `hasnt_enum()`.
* Added `enum_has_labels()`.
* Updated the `Makefile` to fix the shebang line in `pg_prove` if
  Perl is found, and to emit a warning if the `$PERL` variable is not
  set. - Updated the `Makefile` so that if `$PERL` is set and
  TAP::Harness is not installed, it warns the user to install it in
  order to use `pg_prove`. - Updated the `Makefile` to set the location
  of the `psql` binary to the bin directory specified for PostgreSQL
  when it was built.
* Fixed `pg_version_num()` to work on PostgreSQL 8.4devel.
* Fixed test failures on PostgreSQL 8.4devel.

0.15  2009-01-20T18:41:24Z
--------------------------
* Changed `pg_typeof()` from immutable to stable, in compliance with its
  configuration in the forthcoming PostgreSQL 8.4.
* Added `do_tap()`, which finds test functions and runs them, allowing
  tap tests to be embedded in functions and then executed all at once.
* Added `runtests()`, which introduces xUnit-style test running, for
  those who prefer to put their tests in a slew of test functions and
  then run one function to run all of the test functions (plus startup,
  setup, teardown, and shutdown tests).
* Added `findfuncs()`, which is used by `do_tap()` to find the functions
  to execute.
* The `col_type_is()` function now requires that the type be visible in
  the search path when it is called without a schema argument.
* The `plan()` function no longer resets the `client_min_messages`
  setting to its default value, but leaves it set to whatever it was set
  to before the function was called.
* Fixed a typo in the documentation of the short version of the
  `--version` option to `pg_prove`, which is `-V`, not `-v`.
* Added `pgtap_version()`.
* Added the "html" make target to generate the HTML documentation for
  the Web site, including a table of contents and documentation for
  `pg_prove`.

0.14  2008-10-27T22:43:36Z
--------------------------
* Added `SET search_path` statements to `uninstall_pgtap.sql.in` so that
  it will work properly when TAP is installed in its own schema. Thanks to
  Ben for the catch!
* Added commands to drop `pg_version()` and `pg_version_num()`
  to`uninstall_pgtap.sql.in`.
* Added `has_index()`, `index_is_unique()`, `index_is_primary()`,
  `is_clustered()`, and `index_is_type()`.
* Added `os_name()`. This is somewhat experimental. If you have `uname`,
  it's probably correct, but assistance in improving OS detection in the
  `Makefile` would be greatly appreciated. Notably, it does not detect
  Windows.
* Made `ok()` smarter when the test result is passed as `NULL`. It was
  dying, but now it simply fails and attaches a diagnostic message
  reporting that the test result was `NULL`. Reported by Jason Gordon.
* Fixed an issue in `check_test()` where an extra character was removed
  from the beginning of the diagnostic output before testing it.
* Fixed a bug comparing `name[]`s on PostgreSQL 8.2, previously hacked
  around.
* Added `has_trigger()` and `trigger_is()`.
* Switched to pure SQL implementations of the `pg_version()` and
  `pg_version_num()` functions, to simplify including pgTAP in module
  distributions.
* Added a note to `README.pgtap` about the need to avoid `pg_typeof()`
  and `cmp_ok()` in tests run as part of a distribution.

0.13  2008-10-13T19:09:46Z
--------------------------
* Added `pg_version()` and `pg_version_num()`.
* Documented `pg_typeof()`.

0.12  2008-10-11T04:02:42Z
--------------------------
* Updated `plan()` to disable warnings while it creates its tables.
  This means that `plan()` no longer send NOTICE messages when they run,
  although tests still might, depending on the setting of
  `client_min_messages`.
* Added `hasnt_table()`, `hasnt_view()`, and `hasnt_column()`.
* Added `hasnt_pk()`, `hasnt_fk()`, `col_isnt_pk()`, and
  `col_isnt_fk()`.
* Added missing `DROP` statements to `uninstall_pgtap.sql.in`.

0.11  2008-09-24T20:41:42Z
--------------------------
* Simplified the tests so that they now load `test_setup.sql` instead of
  setting a bunch of stuff themselves. Now only `test_setup.sql` needs
  to be created from `test_setup.sql.in`, and the other `.sql` files
  depend on it, meaning that one no longer has to specify `TAPSCHEMA`
  for any `make` target other than the default.
* Eliminated all uses of `E''` in the tests, so that we don't have to
  process them for testing on 8.0.
* Fixed the spelling of `ON_ROLLBACK` in the test setup. Can't believe I
  had it with one L in all of the test files before! Thanks to Curtis
  "Ovid" Poe for the spot.
* Added a couple of variants of `todo()` and `skip()`, since I can never
  remember whether the numeric argument comes first or second. Thanks to
  PostgreSQL's functional polymorphism, I don't have to. Also, there are
  variants where the numeric value, if not passed, defaults to 1.
* Updated the link to the pgTAP home page in `pgtap.sql.in`.
* TODO tests can now nest.
* Added `todo_start()`, `todo_end()`, and `in_todo()`.
* Added variants of `throws_ok()` that test error messages as well as
  error codes.
* Converted some more tests to use `check_test()`.
* Added `can()` and `can_ok()`.
* Fixed a bug in `check_test()` where the leading white space for
  diagnostic messages could be off by 1 or more characters.
* Fixed the `installcheck` target so that it properly installs PL/pgSQL
  into the target database before the tests run.

0.10  2008-09-18T22:59:31Z
--------------------------
* Changed `pg_prove` to set `QUIET=1` when it runs, so as to prevent the
  output of extraneous stuff.
* Added some `GRANT` statements to `plan()` in order to make it easier
  to run tests using roles other than the one that called `plan()`.
  Patch from Rod Taylor.
* Replaced a call to `lastval()` with a call to `currval()` in order to
  improve compatibility with PostgreSQL 8.0. Reported by David Westbrook.
* Added support for TODO and SKIP tests.
* Removed the few uses of named parameters and added alias names instead.
  This improves compatibility for versions of PostgreSQL prior to 8.0.
  Reported by David Westbrook.
* Fixed the plural of "test" in the output from `finish()`. It was
  plural when there was one test and singular otherwise. So I reversed
  that.
* Moved assignment to declared variables from the `DECLARE` block to the
  body of the functions. Improves compatibility with versions of
  PostgreSQL prior to 8.0. Reported by David Westbrook.
* Eliminated passing the result of a function call to `RAISE` in order
  to better support older versions of PostgreSQL. Reported by David
  Westbrook.
* Switched from using `FOUND` to `GET DIAGNOSTICS ROW_COUNT` because the
  former does not seem to be set for `EXECUTE` SQL in older versions of
  PostgreSQL. Reported by David Westbrook.
* Added tests specifically targeting PostgreSQL 7.3. From David
  Westbrook.
* Ported all the way back to PostgreSQL 8.0, thanks to some Makefile
  hackery and a patch file. All tests pass on 8.0, 8.1, 8.2, and 8.3.
  The only exception is `throws_ok()` and `lives_ok()`, which are not
  supported on 8.0. Versions of PostgreSQL lower than 8.0 are not yet
  supported, even though we have made some changes to simplify getting
  things to work in earlier versions.
* Changed "got/expected" to "have/want", following Schwern's plans for
  Test::Builder 2. Also changed "caught/expected" to "caught/wanted" for
  nice parity when outputting diagnostics for exception testing.
* Added the `has_table()`, `has_view()`, `has_column()`, `has_pk()`,
  `has_fk()`, `fk_ok()`, `has_unique()` and `has_check()` test
  functions.
* Added the `col_not_null()` and `col_is_null()` test functions.
* Added the `col_type_is()`, `col_default_is()`, `col_is_pk()`,
  `col_is_fk()`, `col_is_unique()`, and `col_has_check()` test
  functions.
* Fixed `is()` and `isnt()` to better handle `NULL`s.
* Added `cmp_ok()`.
* Added the `--set ON_ERROR_STOP=1` option to the call to `psql` in
  `pg_prove`.
* Renamed `drop_pgtap.sql.in` to `uninstall_pgtap.sql.in`, which is more
  in line with typical PostgreSQL contrib modules.
* Removed verbose output of the `psql` command from `pg_prove`. Thanks
  to Andy Armstrong for the spot.
* Divided the tests up into many separate test script files, so that
  things are a bit better organized and easier to maintain.
* Added the `check_test()` function and started converting internal
  tests to use it instead of the hacked stuff they were doing before.
* As in Test::Builder 0.81_01, changed the message for extra tests run
  to show the number of tests run rather than the number extra to avoid
  the user having to do mental math.
* The regression test files are now processed by `make installcheck` and
  `make test` so that the schema can be properly set, if pgTAP is built
  with a schema.

0.02  2008-06-17T16:26:41Z
--------------------------
* Converted the documentation to Markdown.
* Added pg_prove, a Perl script that use TAP::Harness to run tests and
  report the results, just like the Perl program `prove`.
* Fixed `no_plan()` so that it no longer emits a plan, which apparently
  was wrong. Now `finish()` outputs it when there's no plan.
* Fixed the test script so that it now emits a proper plan.
* Removed all of the configuration settings from `pgtap.sql`, as they're
  now handled by `pg_prove`. I've mentioned them in the README for
  reference.
* Added `lives_ok()`.
* Moved the creation of temporary tables into `plan()`, so that
  everything is properly self-contained.
* Improved the handling of transactions. Test scripts are now assumed to
  be single transactions with a ROLLBACK at the end. This makes it so
  that test scripts don't have to include `drop_pgtap.sql`.
* Updated `pg_prove` to rollback on an error, rather than just stop.
  This allows all test functions to be properly rolled back, too, in a
  test script that includes them but then encounters an unhandled
  exception.
* Updated `pg_prove` to emit an appropriate error message if no test
  scripts are specified.
* Added a Makefile. It uses the typical PostgreSQL installation
  procedures to install pgTAP. The SQL files have now been turned into
  `.in` templates that are processed by `make`.
* Added support for schema qualification of test functions. Just set the
  `$TAPSCHEMA` environment variable when running `make`.
* Added support for standard PostgreSQL-type regression testing by just
  copying the test script, setting some variables inside it, and
  providing an `expected/` directory. The test now lives in the `sql/`
  directory.
* Changed all instances of `RETURN QUERY SELECT` to `RETURN NEXT`, which
  should allow pgtap to run on versions of PostgreSQL earlier than 8.3.
  Thanks to Neil Conway for the suggestion.

0.01  2008-06-07T05:24:27Z
--------------------------
* Initial public release. Announcement at
  http://justatheory.com/computers/databases/postgresql/introducing_pgtap.html