fix unit test broken in last commit, add new test for pgsql unit tests