Add 'DISCARD ALL' to PostgreSQLAdapter#clear_cache

Reset Postgres connection session state (which includes prepared statements) when checking in an active connection. See discussion at #14037