Hope this will be helpful for agile developers.
http://en.dklab.ru/lib/dklab_pgunit/
PGUnit is a xUnit-style framework for stored procedures in PostgreSQL 8.3+. It allows database developers to write automated tests for existed stored procedures or develop procedures using concepts of Test Driven Development (TDD). All test cases are stored in the database, so you don't need any external resources (like files, version control, command-line utilities etc.) to save tests.
As in traditional xUnit, tests may be grouped in test case; each test-case may have
its own environment initialization code ("fixture preparation code", or setUp block).
The main benefit of PGUnit is that setUp block (usually quite CPU intensive) is
executed only once, and its effect is stored in a savepoint. Then, all tests
are executed from that savepoint, so the fixture initialization overheat is
minimal. All tests are still executed independently, because their effects are
automatically rolled back after the execution.