Running a query requires a begin/end block - Githubissues

microsoft / vscode-postgresql

PostgreSQL extension for VSCODE

Other

422 stars 53 forks source link

Running a query requires a begin/end block #49

Open Cabeda opened 5 years ago

Cabeda commented 5 years ago

PGSQL Extension Version: 0.2.0
VSCode Version: 1.35.1
OS Version: MacOs Mojave 10.14.5

Steps to Reproduce:

Run query 'SELECT * FROM pg_stat_activity;';
Result returns 'cursors can only be used within the transaction that created them. '
Run query BEGIN; SELECT * FROM pg_stat_activity; END;
Query returns the result correctly

Is this the supposed to happen?