bug: incorrect execution of the START TRANSACTION command

[konstantinovaleksej]

Steps to reproduce the behavior:

1. Enter this test code:

SHOW work_mem;
START TRANSACTION;
SET LOCAL work_mem TO '8MB';
SHOW work_mem;
ROLLBACK;
SHOW work_mem;

2. Select all the code and press Shift+Enter to execute the query or click the Run button on the toolbar;

3. See error in the PostgreSQL Query Result panel:
   4MB
   4MB
   4MB

4. But! If we replace the START command with the BEGIN command and execute this code again, the result will be correct:

SHOW work_mem;
BEGIN TRANSACTION;
SET LOCAL work_mem TO '8MB';
SHOW work_mem;
ROLLBACK;
SHOW work_mem;

4MB
8MB
4MB

PostgreSQL extension:
Identifier: ms-ossdata.vscode-pgsql
Version: 1.16.0

VSCode:
Version: 1.109.5 (system setup)
Commit: 072586267e68ece9a47aa43f8c108e0dcbf44622
Date: 2026-02-19T19:43:32.382Z
Electron: 39.3.0
ElectronBuildId: 13313481
Chromium: 142.0.7444.265
Node.js: 22.21.1
V8: 14.2.231.22-electron.0
OS: Windows_NT x64 10.0.19045