Data base sanity checks

[Berend Tober <..hidden..>]

I know there was a discussion about incorporating pg-tap into 
LedgerSMB, but I imagine that will require some longer-term effort.

I am wondering if in the mean time there would be a good way to 
perform some basic automated sanity checks indicating the 
prepare-database has done everything it is intended ... like 
maybe count the number of tables, functions, domains, and etc.

When testing trunk, oftentimes errors and rollbacks occur, and I 
can recognize that when only two tables end up being created that 
something went wrong, but how would I know that 124 or 157 or 
whatever tables is the right number? I know I can redirect the 
output of the script to a file and grep for ERROR, which I do, 
but there are some inconsequential "errors" like objects already 
existing. I was thinking about some built-in automated 
correctness checking so the script can tell me directly if it 
completed all tasks.