Comment 3 for bug 1194246

I've been doing some work in collab/phasefx/pgtap_generator that I plan to squash down and cherry-pick into collab/phasefx/pgtap when I'm a bit father along. It adds a script, make-pgtap-tests.pl, with the idea that once the dev community has bought into the idea of maintaining pgTAP tests we can use that script to create a baseline set of schema tests that we can then commit to master and from then on modify whenever we create database upgrade scripts (before or after).

Any thoughts, comments, etc. on this? Right now the generated tests look like this:
http://nox.esilibrary.com/~jason/qa/make-pgtap-tests.pl.pg.2013-07-24.txt

and the output looks like this if ran directly in psql:
http://nox.esilibrary.com/~jason/qa/make-pgtap-tests.pl.pg.2013-07-24.out.txt

Or with pg_prove:

opensrf@dev141:~/git/Evergreen/Open-ILS/src/sql/Pg (pgtap)$ pg_prove -d evergreen2 test.pg
test.pg .. ok
All tests successful.
Files=1, Tests=12118, 44 wallclock secs ( 1.72 usr 0.23 sys + 0.66 cusr 0.82 csys = 3.43 CPU)
Result: PASS