I'm using vscode 1.74.2 with SQLTools extension v0.26.0 with postgresql 15.
when I run a query that results in an error in psql it returns error output in several namespaces, for example in my case when i run a function that i created the returns wrong result type, it's divided to 3 sections:
ERROR: structure of query does not match function result type
DETAIL: Returned type numeric does not match expected type integer in column 11.
CONTEXT: SQL statement "..."
when I try to execute it i only see the error, the detail is important to understand exactly what went wrong
i tried looking at the sql console messages but it only shows the error as well.
am i missing something? is this something configurable ? if it was it looks like it should have been enabled my default
I'm using vscode 1.74.2 with SQLTools extension v0.26.0 with postgresql 15.
when I run a query that results in an error in psql it returns error output in several namespaces, for example in my case when i run a function that i created the returns wrong result type, it's divided to 3 sections:
when I try to execute it i only see the error, the detail is important to understand exactly what went wrong
i tried looking at the sql console messages but it only shows the error as well.
am i missing something? is this something configurable ? if it was it looks like it should have been enabled my default