Remove test headers and clean up Makefile

A bunch of the test headers had something of the form `! ./src`, which had to do with pg_regress. Since we're no longer using pg_regress, the test files no longer require this header.