microsoft / microsoft/vscode-pgsql

intelliSense and syntax check doesn't work

Open
#173 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

Describe the bug

It just doesn't work,may be it's because I didn't install microsoft visual C++ pack.

To Reproduce

open my computer,and open an sql file,the syntax check doesn't work

Image

Expected behavior

I Hope to know where can i find the log to solve this problem.
I'm a noob for these.

Screenshots

VS Code version
[08:47:28] [ToolsService] [Information]: ToolsService: registerTools called [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_list_servers [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_connect [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_disconnect [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_open_script [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_visualize_schema [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_query [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_modify [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_db_context [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_list_databases [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_describe_csv [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_bulk_load_csv [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_get_dashboard_context [08:47:28] [ToolsService] [Information]: Registering tool: pgsql_get_metric_data [08:47:50] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent) [08:47:51] 对于文档“file:///c:/Users/EDY/Desktop/写过的程序/销售数据/面包测试脚本-dwd清洗.pgsql”,正在连接到服务器“localhost”。 [08:47:52] 对于文档“file:///c:/Users/EDY/Desktop/写过的程序/销售数据/面包测试脚本-dwd清洗.pgsql”,已连接到服务器“localhost”。服务器信息: {"isCloud":false,"server":"PostgreSQL","serverVersion":"18.0.0"} [08:47:52] 对于文档“objectexplorer://bread@localhost:5432:postgres/”,正在连接到服务器“localhost”。 [08:47:52] 对于文档“objectexplorer://bread@localhost:5432:postgres/”,已连接到服务器“localhost”。服务器信息: {"isCloud":false,"server":"PostgreSQL","serverVersion":"18.0.0"} [08:49:49] [ObjectExplorerService] [All]: Getting root OE nodes [08:49:49] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent) [08:49:49] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://bread@localhost:5432:postgres/' [08:52:23] [pgQueryResult] [All]: QueryResultPane is ready to receive state updates [08:52:23] [pgQueryResult] [All]: Query result view is ready, checking queued state updates for 0 URIs [08:52:23] [pgQueryResult] [All]: Current active editor URI: file:///c:/Users/EDY/Desktop/写过的程序/销售数据/面包测试脚本-dwd清洗.pgsql

Extension Logs

See: https://github.com/microsoft/vscode-pgsql?tab=readme-ov-file#usage-and-feedback

Add any other context about the problem here.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the problem in the VS Code PostgreSQL extension with the provided .pgsql file and review the extension logs linked in the issue. Compare the behavior for a PostgreSQL connection on localhost and identify what prevents IntelliSense or syntax checking; done means the failure is explained and the check works or a clear diagnostic is reported.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.