Add graceful handling in some hooks when temp name space is deleted by concurrent postgres sessions

Add graceful handling in some hooks when temp name space is deleted by concurrent postgres sessions #9739