adding test case for postgresql connector