Forum Discussion

Moynzy's avatar
Moynzy
Copper Contributor
Feb 24, 2024

Unhandled exception while executing query: 'list' object has no attribute 'encode'

Azure Studio:

Version: 1.47.1 (user setup)
Commit: b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e
Date: 2024-01-10T02:15:02.628Z
VS Code: 1.82.0
Electron: 25.8.4
Chromium: 114.0.5735.289
Node.js: 18.15.0
V8: 11.4.183.29-electron.0
OS: Windows_NT x64 10.0.19045

 

 

When running the below: 

select * from pg_database;
 
I get:

 

 

Please kindly assist Microsoft?

 

  • DanielGahler's avatar
    DanielGahler
    Copper Contributor
    Mar 09, 2024
    Hi, I have the exact same issue (We probably both came here from a Linkedin Learning course?). I'm assuming it's to do with the most recent version of the PostgreSQL extension on Azure Data Studio (v0.6.0). Sadly I cannot downgrade manually.
    Can you confirm that the query
    "SELECT * FROM pg_stat_activity;"
    executes without error?
    My workaround is using actual VSCode, and the Microsoft PostgreSQL extension therein (v0.3.0)
    It's a bit more difficult to set up but there's instructions in the extension description are helpful.

Resources