You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using vscode version 1.74.2 with SQLTools extension v0.26.0 On MacOS Monterey 12.6.2 in order to work with a postgresql 15 database.
when i'm writing a plpgsql function, the editor marks in color the function besides the last line of END $$ LANGUAGE plpgsql.
SQLTools provides the shortcut called SQLTools Connection: Run current query
i can't use it because i get unterminated quoted string error.
so when I try to execute the run current query shortcut i get the following error:
unterminated dollar-quoted string at or near "$$ BEGIN return query select 1::int;" at character 61
I created a sample code:
create or replace function foo() returns table(test int) as $$
BEGIN
return query select 1::int;
END $$ LANGUAGE plpgsql;
of course if i manually mark all the 4 lines and then run the query it creates the function properly, but this is very annoying since this is an example and i deal with complex functions and to start marking all of them in order to execute them each time is a hassle.
The text was updated successfully, but these errors were encountered:
I'm using vscode version 1.74.2 with SQLTools extension v0.26.0 On MacOS Monterey 12.6.2 in order to work with a postgresql 15 database.
when i'm writing a plpgsql function, the editor marks in color the function besides the last line of END $$ LANGUAGE plpgsql.
SQLTools provides the shortcut called SQLTools Connection: Run current query
i can't use it because i get unterminated quoted string error.
so when I try to execute the run current query shortcut i get the following error:
unterminated dollar-quoted string at or near "$$ BEGIN return query select 1::int;" at character 61
I created a sample code:
of course if i manually mark all the 4 lines and then run the query it creates the function properly, but this is very annoying since this is an example and i deal with complex functions and to start marking all of them in order to execute them each time is a hassle.
The text was updated successfully, but these errors were encountered: