completed changes for pgres
completed changes for pgres