rollback postgresql in tests
omit indexes which include system columns
update deprecated imports
analyze function arguments and return type