Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

LSP doesn't work (in a strange way) #325

Unanswered
DaviDevMod asked this question in Q&A
Discussion options

I'm on Ubuntu 24.04.2 LTS.
The CLI is installed through node with npm i -D @postgrestools/postgrestools.
Using VSCode, with a seemingly working extension where running PostgresTools: Get Current Version yelds: "Currently installed PostgresTools version is 0.3.1."

This is my postgrestools.jsonc

{
// #319
"$schema": "https://pgtools.dev/schemas/latest/schema.json",
"vcs": {
"enabled": false,
"clientKind": "git",
"useIgnoreFile": false
},
"files": {
"ignore": []
},
"linter": {
"enabled": true,
"rules": {
"recommended": true
}
},
"db": {
"host": "127.0.0.1",
"port": 5432,
"username": "postgres",
"password": "postgres",
"database": "postgres",
"connTimeoutSecs": 10
}
}

I have a simple .sql file with two tables.
-- Create the company table
CREATE TABLE company (
 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
 name VARCHAR(255) NOT NULL,
 email VARCHAR(255) UNIQUE NOT NULL
);
-- Create the business table
CREATE TABLE business (
 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
 name VARCHAR(255) NOT NULL,
 email VARCHAR(255) UNIQUE NOT NULL,
 company_id UUID REFERENCES company(id) NOT NULL,
 INDEX (company_id)
);

After reloading the editor, I get squiggling lines in the entire second table, with a pg(syntax) error saying Invalid statement: syntax error at or near "(".

After running PostgresTools: Restart the error goes away, but now I can also get away with writing gibberish.

Here's the postgrestools server output

2025年04月09日 23:41:43.418 [info] PostgresTools extension 1.1.5 activated
2025年04月09日 23:41:43.418 [info] Starting with config...
config={"enabled":true,"allowDownloadPrereleases":false,"configFile":"","bin":null}
2025年04月09日 23:41:43.418 [info] User-facing commands registered
2025年04月09日 23:41:43.418 [info] User did not specify path to config file. Using default.
2025年04月09日 23:41:43.418 [info] Found config file.
path="/home/censored/Desktop/censored/postgrestools.jsonc"
2025年04月09日 23:41:43.418 [info] Binary not found with strategy
strategy="VSCode Settings Strategy"
2025年04月09日 23:41:43.419 [info] Searching for node_modules package
postgrestoolsPackageNameJson="@postgrestools/postgrestools/package.json"
2025年04月09日 23:41:43.419 [info] Copying binary to temp location
currentLocation="/home/censored/Desktop/censored/node_modules/@postgrestools/cli-x86_64-linux-gnu/postgrestools"
2025年04月09日 23:41:43.714 [info] Server Options:
serverOptions={"command":"/home/censored/.config/Code/User/globalStorage/supabase.postgrestools/tmp-bin/postgrestools-0.3.1","transport":0,"options":{"cwd":"/home/censored/Desktop/censored"},"args":["lsp-proxy","--config-path=/home/censored/Desktop/censored/postgrestools.jsonc"]}
2025年04月09日 23:41:45.352 [info] Created a global LSP session
2025年04月09日 23:41:45.352 [info] PostgresTools extension started
2025年04月09日 23:41:45.353 [info] Started listening for configuration changes
2025年04月09日 23:41:45.353 [info] Started listening for active text editor changes

Running PostgresTools: Restart just adds the line 2025年04月09日 23:42:57.073 [info] PostgresTools extension restarted

And here's the log took from ~/.cache/pgt/pgt-logs/server.log.2025年04月09日-22

┐pgt_cli::commands::daemon::Running Server{pid=107497}
├─2025年04月09日 22:16:17.96371738 0ms INFO pgt_cli::service::unix Trying to connect to socket /home/cersored/.cache/pgt/pgt-socket-0.3.1
├─2025年04月09日 22:16:17.963753409 0ms INFO pgt_cli::service::unix Remove socket folder /home/cersored/.cache/pgt/pgt-socket-0.3.1
├─2025年04月09日 22:16:18.009494502 45ms INFO pgt_cli::service::unix Accepted connection
├─2025年04月09日 22:16:18.009633112 46ms INFO pgt_cli::service::unix Accepted connection
└─┐pgt_lsp::server::initialize{root_uri=file:///home/cersored/Desktop/my%20packages/censored, capabilities=ClientCapabilities { workspace: Some(WorkspaceClientCapabilities { apply_edit: Some(true), workspace_edit: Some(WorkspaceEditClientCapabilities { document_changes: Some(true), resource_operations: Some([Create, Rename, Delete]), failure_handling: Some(TextOnlyTransactional), normalizes_line_endings: Some(true), change_annotation_support: Some(ChangeAnnotationWorkspaceEditClientCapabilities { groups_on_label: Some(true) }) }), did_change_configuration: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), did_change_watched_files: Some(DidChangeWatchedFilesClientCapabilities { dynamic_registration: Some(true), relative_pattern_support: Some(true) }), symbol: Some(WorkspaceSymbolClientCapabilities { dynamic_registration: Some(true), symbol_kind: Some(SymbolKindCapability { value_set: Some([File, Module, Namespace, Package, Class, Method, Property, Field, Constructor, Enum, Interface, Function, Variable, Constant, String, Number, Boolean, Array, Object, Key, Null, EnumMember, Struct, Event, Operator, TypeParameter]) }), tag_support: Some(TagSupport { value_set: [Deprecated] }), resolve_support: Some(WorkspaceSymbolResolveSupportCapability { properties: ["location.range"] }) }), execute_command: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), workspace_folders: Some(true), configuration: Some(true), semantic_tokens: Some(SemanticTokensWorkspaceClientCapabilities { refresh_support: Some(true) }), code_lens: Some(CodeLensWorkspaceClientCapabilities { refresh_support: Some(true) }), file_operations: Some(WorkspaceFileOperationsClientCapabilities { dynamic_registration: Some(true), did_create: Some(true), will_create: Some(true), did_rename: Some(true), will_rename: Some(true), did_delete: Some(true), will_delete: Some(true) }), inline_value: Some(InlineValueWorkspaceClientCapabilities { refresh_support: Some(true) }), inlay_hint: Some(InlayHintWorkspaceClientCapabilities { refresh_support: Some(true) }), diagnostic: None }), text_document: Some(TextDocumentClientCapabilities { synchronization: Some(TextDocumentSyncClientCapabilities { dynamic_registration: Some(true), will_save: Some(true), will_save_wait_until: Some(true), did_save: Some(true) }), completion: Some(CompletionClientCapabilities { dynamic_registration: Some(true), completion_item: Some(CompletionItemCapability { snippet_support: Some(true), commit_characters_support: Some(true), documentation_format: Some([Markdown, PlainText]), deprecated_support: Some(true), preselect_support: Some(true), tag_support: Some(TagSupport { value_set: [Deprecated] }), insert_replace_support: Some(true), resolve_support: Some(CompletionItemCapabilityResolveSupport { properties: ["documentation", "detail", "additionalTextEdits"] }), insert_text_mode_support: Some(InsertTextModeSupport { value_set: [AsIs, AdjustIndentation] }), label_details_support: Some(true) }), completion_item_kind: Some(CompletionItemKindCapability { value_set: Some([Text, Method, Function, Constructor, Field, Variable, Class, Interface, Module, Property, Unit, Value, Enum, Keyword, Snippet, Color, File, Reference, Folder, EnumMember, Constant, Struct, Event, Operator, TypeParameter]) }), context_support: Some(true), insert_text_mode: Some(AdjustIndentation), completion_list: Some(CompletionListCapability { item_defaults: Some(["commitCharacters", "editRange", "insertTextFormat", "insertTextMode", "data"]) }) }), hover: Some(HoverClientCapabilities { dynamic_registration: Some(true), content_format: Some([Markdown, PlainText]) }), signature_help: Some(SignatureHelpClientCapabilities { dynamic_registration: Some(true), signature_information: Some(SignatureInformationSettings { documentation_format: Some([Markdown, PlainText]), parameter_information: Some(ParameterInformationSettings { label_offset_support: Some(true) }), active_parameter_support: Some(true) }), context_support: Some(true) }), references: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), document_highlight: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), document_symbol: Some(DocumentSymbolClientCapabilities { dynamic_registration: Some(true), symbol_kind: Some(SymbolKindCapability { value_set: Some([File, Module, Namespace, Package, Class, Method, Property, Field, Constructor, Enum, Interface, Function, Variable, Constant, String, Number, Boolean, Array, Object, Key, Null, EnumMember, Struct, Event, Operator, TypeParameter]) }), hierarchical_document_symbol_support: Some(true), tag_support: Some(TagSupport { value_set: [Deprecated] }) }), formatting: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), range_formatting: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), on_type_formatting: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), declaration: Some(GotoCapability { dynamic_registration: Some(true), link_support: Some(true) }), definition: Some(GotoCapability { dynamic_registration: Some(true), link_support: Some(true) }), type_definition: Some(GotoCapability { dynamic_registration: Some(true), link_support: Some(true) }), implementation: Some(GotoCapability { dynamic_registration: Some(true), link_support: Some(true) }), code_action: Some(CodeActionClientCapabilities { dynamic_registration: Some(true), code_action_literal_support: Some(CodeActionLiteralSupport { code_action_kind: CodeActionKindLiteralSupport { value_set: ["", "quickfix", "refactor", "refactor.extract", "refactor.inline", "refactor.rewrite", "source", "source.organizeImports"] } }), is_preferred_support: Some(true), disabled_support: Some(true), data_support: Some(true), resolve_support: Some(CodeActionCapabilityResolveSupport { properties: ["edit"] }), honors_change_annotations: Some(true) }), code_lens: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), document_link: Some(DocumentLinkClientCapabilities { dynamic_registration: Some(true), tooltip_support: Some(true) }), color_provider: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), rename: Some(RenameClientCapabilities { dynamic_registration: Some(true), prepare_support: Some(true), prepare_support_default_behavior: Some(Identifier), honors_change_annotations: Some(true) }), publish_diagnostics: Some(PublishDiagnosticsClientCapabilities { related_information: Some(true), tag_support: Some(TagSupport { value_set: [Unnecessary, Deprecated] }), version_support: Some(false), code_description_support: Some(true), data_support: Some(true) }), folding_range: Some(FoldingRangeClientCapabilities { dynamic_registration: Some(true), range_limit: Some(5000), line_folding_only: Some(true), folding_range_kind: Some(FoldingRangeKindCapability { value_set: Some([Comment, Imports, Region]) }), folding_range: Some(FoldingRangeCapability { collapsed_text: Some(false) }) }), selection_range: Some(SelectionRangeClientCapabilities { dynamic_registration: Some(true) }), linked_editing_range: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), call_hierarchy: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), semantic_tokens: Some(SemanticTokensClientCapabilities { dynamic_registration: Some(true), requests: SemanticTokensClientCapabilitiesRequests { range: Some(true), full: Some(Delta { delta: Some(true) }) }, token_types: [SemanticTokenType("namespace"), SemanticTokenType("type"), SemanticTokenType("class"), SemanticTokenType("enum"), SemanticTokenType("interface"), SemanticTokenType("struct"), SemanticTokenType("typeParameter"), SemanticTokenType("parameter"), SemanticTokenType("variable"), SemanticTokenType("property"), SemanticTokenType("enumMember"), SemanticTokenType("event"), SemanticTokenType("function"), SemanticTokenType("method"), SemanticTokenType("macro"), SemanticTokenType("keyword"), SemanticTokenType("modifier"), SemanticTokenType("comment"), SemanticTokenType("string"), SemanticTokenType("number"), SemanticTokenType("regexp"), SemanticTokenType("operator"), SemanticTokenType("decorator")], token_modifiers: [SemanticTokenModifier("declaration"), SemanticTokenModifier("definition"), SemanticTokenModifier("readonly"), SemanticTokenModifier("static"), SemanticTokenModifier("deprecated"), SemanticTokenModifier("abstract"), SemanticTokenModifier("async"), SemanticTokenModifier("modification"), SemanticTokenModifier("documentation"), SemanticTokenModifier("defaultLibrary")], formats: [TokenFormat("relative")], overlapping_token_support: Some(false), multiline_token_support: Some(false), server_cancel_support: Some(true), augments_syntax_tokens: Some(true) }), moniker: None, type_hierarchy: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), inline_value: Some(DynamicRegistrationClientCapabilities { dynamic_registration: Some(true) }), inlay_hint: Some(InlayHintClientCapabilities { dynamic_registration: Some(true), resolve_support: Some(InlayHintResolveClientCapabilities { properties: ["tooltip", "textEdits", "label.tooltip", "label.location", "label.command"] }) }), diagnostic: Some(DiagnosticClientCapabilities { dynamic_registration: Some(true), related_document_support: Some(false) }) }), window: Some(WindowClientCapabilities { work_done_progress: Some(true), show_message: Some(ShowMessageRequestClientCapabilities { message_action_item: Some(MessageActionItemCapabilities { additional_properties_support: Some(true) }) }), show_document: Some(ShowDocumentClientCapabilities { support: true }) }), general: Some(GeneralClientCapabilities { regular_expressions: Some(RegularExpressionsClientCapabilities { engine: "ECMAScript", version: Some("ES2020") }), markdown: Some(MarkdownClientCapabilities { parser: "marked", version: Some("1.1.0"), allowed_tags: None }), stale_request_support: Some(StaleRequestSupportClientCapabilities { cancel: true, retry_on_content_modified: ["textDocument/semanticTokens/full", "textDocument/semanticTokens/range", "textDocument/semanticTokens/full/delta"] }), position_encodings: Some([PositionEncodingKind("utf-16")]) }), experimental: None }, client_info=ClientInfo { name: "Visual Studio Code", version: Some("1.98.2") }, workspace_folders=[WorkspaceFolder { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored", query: None, fragment: None }, name: "rotime" }]}
├─2025年04月09日 22:16:18.085504461 0ms INFO pgt_lsp::server Starting Language Server...
┌─┘
└─┐pgt_lsp::server::initialized{}
├─2025年04月09日 22:16:19.316699855 0ms INFO pgt_lsp::server Attempting to load the configuration from 'postgrestools.jsonc' file
└─┐pgt_fs::fs::os::OsFileSystem::open_with_options{path="/home/cersored/Desktop/censored/postgrestools.jsonc", options=OpenOptions { read: true, write: false, truncate: false, create: false, create_new: false }}
┌─┘
└─┐pgt_fs::fs::os::OsFile::read_to_string{}
┌─┘
├─2025年04月09日 22:16:19.316912539 0ms INFO pgt_lsp::session Configuration loaded successfully from disk.
├─2025年04月09日 22:16:19.316926038 0ms INFO pgt_lsp::session Update workspace settings.
├─2025年04月09日 22:16:19.316985385 0ms INFO pgt_workspace::workspace::server Updating settings in workspace
├─2025年04月09日 22:16:19.317013924 0ms INFO pgt_workspace::workspace::server Updated settings in workspace
├─2025年04月09日 22:16:19.317262229 0ms WARN sqlx_postgres::options::pgpass Failed to open .pgpass file: Os { code: 2, kind: NotFound, message: "No such file or directory" }, path=/home/cersored/.pgpass
├─2025年04月09日 22:16:19.317340232 0ms INFO pgt_workspace::workspace::server Updated Db connection settings
└─┐pgt_lsp::handlers::text_document::did_open{params=DidOpenTextDocumentParams { text_document: TextDocumentItem { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None }, language_id: "sql", version: 1, text: "-- Create the company table\nCREATE TABLE company (\n id UUID PRIMARY KEY DEFAULT gen_random_uuid(),\n name VARCHAR(255) NOT NULL,\n email VARCHAR(255) UNIQUE NOT NULL\n);\n\n-- Create the business table\nCREATE TABLE business (\n id UUID PRIMARY KEY DEFAULT gen_random_uuid(),\n name VARCHAR(255) NOT NULL,\n email VARCHAR(255) UNIQUE NOT NULL,\n company_id UUID REFERENCES company(id) NOT NULL,\n INDEX (company_id)\n);" } }}
└─┐pgt_workspace::workspace::server::open_file{path="/home/cersored/Desktop/censored/src/lib/supabase/schemas/wip.sql"}
├─2025年04月09日 22:16:19.434486287 2ms INFO pgt_workspace::workspace::server::pg_query invalid statement, adding diagnostics.
┌─┘
├─2025年04月09日 22:16:19.43762011 5ms INFO pgt_workspace::workspace::server Pulled 1 diagnostic(s)
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 2, character: 50 }, end: Position { line: 2, character: 50 } }, context: CodeActionContext { diagnostics: [], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 2, character: 50 }, end: Position { line: 2, character: 50 } }, context: CodeActionContext { diagnostics: [], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
├─2025年04月09日 22:16:20.027526498 710ms INFO pgt_lsp::session Unregister capabilities "workspace/didChangeConfiguration, workspace/didChangeWatchedFiles"
├─2025年04月09日 22:16:20.441745621 1s INFO pgt_lsp::session Register capabilities "workspace/didChangeConfiguration, workspace/didChangeWatchedFiles"
├─2025年04月09日 22:16:20.444812423 1s INFO pgt_workspace::workspace::server Pulled 1 diagnostic(s)
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 2, character: 50 }, end: Position { line: 2, character: 50 } }, context: CodeActionContext { diagnostics: [], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 2, character: 50 }, end: Position { line: 2, character: 50 } }, context: CodeActionContext { diagnostics: [], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 2, character: 50 }, end: Position { line: 2, character: 50 } }, context: CodeActionContext { diagnostics: [], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 14, character: 2 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::server::did_change_configuration{}
└─┐pgt_fs::fs::os::OsFileSystem::open_with_options{path="/home/cersored/Desktop/censored/postgrestools.jsonc", options=OpenOptions { read: true, write: false, truncate: false, create: false, create_new: false }}
┌─┘
└─┐pgt_fs::fs::os::OsFile::read_to_string{}
┌─┘
├─2025年04月09日 22:16:23.978684763 0ms INFO pgt_lsp::session Configuration loaded successfully from disk.
├─2025年04月09日 22:16:23.978703509 0ms INFO pgt_lsp::session Update workspace settings.
├─2025年04月09日 22:16:23.978711895 0ms INFO pgt_workspace::workspace::server Updating settings in workspace
├─2025年04月09日 22:16:23.978725946 0ms INFO pgt_workspace::workspace::server Updated settings in workspace
├─2025年04月09日 22:16:23.978817105 0ms WARN sqlx_postgres::options::pgpass Failed to open .pgpass file: Os { code: 2, kind: NotFound, message: "No such file or directory" }, path=/home/cersored/.pgpass
├─2025年04月09日 22:16:23.979611638 1ms INFO pgt_workspace::workspace::server Updated Db connection settings
├─2025年04月09日 22:16:24.00239522 23ms INFO pgt_lsp::session Unregister capabilities "workspace/didChangeConfiguration, workspace/didChangeWatchedFiles"
├─2025年04月09日 22:16:24.005493875 27ms INFO pgt_lsp::session Register capabilities "workspace/didChangeConfiguration, workspace/didChangeWatchedFiles"
├─2025年04月09日 22:16:24.00586167 27ms INFO pgt_workspace::workspace::server Pulled 1 diagnostic(s)
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 14, character: 2 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: None, trigger_kind: Some(Automatic) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: Some([CodeActionKind("quickfix")]), trigger_kind: Some(Invoked) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: Some([CodeActionKind("quickfix")]), trigger_kind: Some(Invoked) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: Some([CodeActionKind("quickfix")]), trigger_kind: Some(Invoked) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
└─┐pgt_lsp::handlers::code_actions::get_actions{params=CodeActionParams { text_document: TextDocumentIdentifier { uri: Url { scheme: "file", cannot_be_a_base: false, username: "", password: None, host: None, port: None, path: "/home/cersored/Desktop/my%20packages/censored/src/lib/supabase/schemas/wip.sql", query: None, fragment: None } }, range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, context: CodeActionContext { diagnostics: [Diagnostic { range: Range { start: Position { line: 8, character: 0 }, end: Position { line: 14, character: 2 } }, severity: Some(Error), code: Some(String("syntax")), code_description: None, source: Some("pg"), message: "Invalid statement: syntax error at or near "("", related_information: None, tags: None, data: None }], only: Some([CodeActionKind("quickfix")]), trigger_kind: Some(Invoked) }, work_done_progress_params: WorkDoneProgressParams { work_done_token: None }, partial_result_params: PartialResultParams { partial_result_token: None } }}
┌─┘
├─2025年04月09日 22:19:18.957123867 3m INFO tower_lsp::service::layers shutdown request received, shutting down
└─┐pgt_lsp::server::shutdown{}
┌─┘
├─2025年04月09日 22:19:18.959704093 3m INFO tower_lsp::service::layers exit notification received, stopping
2025年04月09日 22:19:18.960535378 INFO pgt_cli::commands::daemon Received shutdown signal

Any insight on what's going on?

You must be logged in to vote

Replies: 1 comment 2 replies

Comment options

This is a bug. Thanks for providing the logs, will look into it over the next days!

You must be logged in to vote
2 replies
Comment options

Thank you so much! Should I open an issue then?

Comment options

No need, will do so later myself. Thanks though!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet

AltStyle によって変換されたページ (->オリジナル) /