Rollback to savepoint is rolling back the entire transaction

### Description

Seems like Problem 2 in #29317 was not addressed or reintroduced.

Executing the following line by line (Ctrl+Enter) in Manual Commit mode
```sql
CREATE TABLE zltest(id INT)

BEGIN TRANSACTION

INSERT INTO zltest VALUES (1)

SAVEPOINT foo

INSERT INTO zltest VALUES (2)

ROLLBACK TO foo

SELECT * FROM zltest
```

at this point the transaction is rolled back and the table does not exists:
(I did not manually trigger the Rollback and could reproduce this behavior every single time I tried)

Interestingly, using `ROLLBACK TRANSACTION TO foo` works as expected:

### DBeaver Version

Community Edition 24.2.1.202409221725

### Operating System

Windows 11 Enterprise 22H2 (OS Build 22621.4169)

### Database and driver

CloudSQL PostgreSQL 14.12, driver: PostgreSQL JDBC 42.5.0

### Steps to reproduce

_No response_

### Additional context

_No response_