Cockroach DB support

Đang mở

#37 mở ngày 23/5/2025 0 bình luận 4 reaction 0 người được giao Xem trên GitHub

Chưa có ai nhận issue này.

Đánh giá

Độ khó: 4/5
Thời gian dự kiến: 3-5 ngày
Mức phù hợp với người mới: 35/100

Loại issue: Lỗi
Độ rõ ràng: Cần làm rõ
Mức độ hoạt động: Đình trệ
Công nghệ: postgresql, vscode
Lĩnh vực: database

Hướng nghiên cứu

Bắt đầu bằng cách tái hiện kết nối CockroachDB và theo dõi các yêu cầu của ObjectExplorerService đối với cơ sở dữ liệu, schema và bảng trong log của extension. Đồng thời kiểm tra entry point pgsql_visualize_schema, sau đó xác minh rằng việc liệt kê bảng và trực quan hóa schema hoạt động với một instance CockroachDB.

Do mô hình lập chỉ mục viết ra từ nội dung của issue.

Mô tả

enhancement

Describe the bug

Right now it seems the extension is able to connect to the DB but no tables are being enumerated, using latest versions of everything, several other things are also not working as expected (visualize etc).

To Reproduce

Steps to reproduce the behavior:

Connect to a CRDB instance.
Attempt to view tables.
See above.
Expected behavior

I'd expect this to work somewhat (best effort) but it seems to be not working at all.

Screenshots

n/a

VS Code version

Version: 1.100.2 (Universal)

Extension Logs

[10:37:01 AM] [PgToolsService Initialization] ServiceDownloadProvider initialized
[10:37:01 AM] [PgToolsService Initialization] Initializing PostgreSQL Tools Service for the pgsql extension.
[10:37:01 AM] [PgToolsService Initialization] Note: pgsql commands will be available after installing the service.
[10:37:01 AM] [PgToolsService Initialization] 
[10:37:01 AM] [PgToolsService Initialization] Platform: darwin, arm64 (OSX)
[10:37:01 AM] [PgToolsService Initialization] 
[10:37:01 AM] [PgToolsService Initialization] Checking server path for runtime ID: OSX_ARM64
[10:37:01 AM] [PgToolsService Initialization] Server path not found for runtime ID: OSX_ARM64
[10:37:01 AM] [PgToolsService Initialization] Downloading server files
[10:37:01 AM] [PgToolsService Initialization] Using tools server filename: osx-arm64.tar.gz
[10:37:01 AM] [PgToolsService Initialization] Installing PostgreSQL Tools Service to /Users/simonschick/.vscode/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/OSX.
[10:37:01 AM] [PgToolsService Initialization] Downloading https://github.com/microsoft/pgsql-tools/releases/download/v2.0.3/pgsqltoolsservice-osx-arm64.tar.gz
[10:37:02 AM] [PgToolsService Initialization] (68876 KB) ....................[Verbose]: Downloaded to /var/folders/gm/xgb679px0svfx4kxgwtdzd400000gn/T/package-71533q9amVNDk5tcE.tmp...
[10:37:06 AM] [PgToolsService Initialization]  Done!
[10:37:06 AM] [PgToolsService Initialization] Installing ...
[10:37:07 AM] [PgToolsService Initialization] Done! 2715 files unpacked.

[10:37:07 AM] [PgToolsService Initialization] Server files downloaded to: /Users/simonschick/.vscode/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/OSX/pgsqltoolsservice/ossdbtoolsservice_main
[10:37:07 AM] [PgToolsService Initialization] Attempting to initialize language client
[10:37:07 AM] [PgToolsService Initialization] Checking overrides for language client initialization
[10:37:07 AM] [PgToolsService Initialization] Creating the language client with options: {"command":"/Users/simonschick/.vscode/extensions/ms-ossdata.vscode-pgsql-1.4.1/pgsqltoolsservice/v2.0.3/OSX/pgsqltoolsservice/ossdbtoolsservice_main","args":["--log-file","/Users/simonschick/Library/Application Support/Code/logs/20250522T115604/window1/exthost/ms-ossdata.vscode-pgsql/sqltools.log","--tracing-level","All","--application-name","Code","--data-path","/Users/simonschick/Library/Application Support","--enable-sql-authentication-provider"],"transport":0}
[10:37:07 AM] [PgToolsService Initialization] Language client created
[10:37:07 AM] [PgToolsService Initialization] Starting language client
[10:37:07 AM] [PgToolsService Initialization] Language client started
[10:37:07 AM] [PgToolsService Initialization] Waiting for client to be ready
[10:37:52 AM] [PgToolsService Initialization] Client is ready
[10:37:52 AM] [ToolsService] [Information]: ToolsService: registerTools called
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_list_servers
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_connect
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_disconnect
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_open_script
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_visualize_schema
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_query
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_modify
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_db_context
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_list_databases
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_describe_csv
[10:37:52 AM] [ToolsService] [Information]: Registering tool: pgsql_bulk_load_csv
[10:39:08 AM] [ObjectExplorerService] [All]: Getting root OE nodes
[10:39:08 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections; excluded recent)
[10:39:08 AM] [ObjectExplorerService] [Verbose]: No saved connections found; displaying 'Add Connection' node
[10:39:10 AM] [connectionDialog] [All]: Initializing connection dialog
[10:39:10 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections (0 from config, 0 from recent))
[10:39:10 AM] [connectionDialog] [All]: Has connection to edit: false
[10:39:10 AM] [PgToolsService Initialization] [Verbose]: Retreived 0 Azure accounts from account store.
[10:39:44 AM] [connectionDialog] [All]: Initializing connection dialog
[10:39:44 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections (0 from config, 0 from recent))
[10:39:44 AM] [connectionDialog] [All]: Has connection to edit: false
[10:39:44 AM] [PgToolsService Initialization] [Verbose]: Retreived 0 Azure accounts from account store.
[10:40:56 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections; excluded recent)
[10:41:11 AM] Error connecting to server "127.0.0.1:26257". Details: 
Connection error:
[Errno 8] nodename nor servname provided, or not known
[10:41:44 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections; excluded recent)
[10:41:45 AM] Connected to server "127.0.0.1" on document "127.0.0.1_concat_test_root_concat local". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"13.0.0"}
[10:41:47 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections; excluded recent)
[10:41:47 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 0 connections; excluded recent)
[10:41:47 AM] [connectionDialog] [All]: Checking for duplicates against 0 profiles
[10:41:47 AM] Connected to server "127.0.0.1" on document "127.0.0.1_concat_test_root_concat local". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"13.0.0"}
[10:41:47 AM] Connecting to server "127.0.0.1" on document "objectexplorer://root@127.0.0.1:26257:concat_test/".
[10:41:47 AM] Connected to server "127.0.0.1" on document "objectexplorer://root@127.0.0.1:26257:concat_test/". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"13.0.0"}
[10:41:47 AM] [mainController] [All]: New Session Dialog: Node created for 8D82AB39-913A-4EF3-A682-4C6FE945C154
[10:41:47 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 2 connections (1 from config, 1 from recent))
[10:41:47 AM] [ObjectExplorerService] [All]: Getting root OE nodes
[10:41:47 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent)
[10:41:47 AM] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://root@127.0.0.1:26257:concat_test/'
[10:41:47 AM] [ObjectExplorerService] [All]: Getting root OE nodes
[10:41:47 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent)
[10:41:47 AM] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://root@127.0.0.1:26257:concat_test/'
[10:41:49 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/'
[10:41:56 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/'
[10:41:57 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/'
[10:41:59 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/'
[10:42:01 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/'
[10:42:06 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/'
[10:42:07 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/tables/'
[10:42:13 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/views/'
[10:43:12 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/'
[10:43:13 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/'
[10:43:15 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/'
[10:43:20 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/1/'
[10:43:23 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/system/'
[10:43:43 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/system/'
[10:43:47 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/4294967295/'
[10:43:48 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/4294967295/tables/'
[10:43:52 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/procedures/'
[10:43:52 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/triggerfunctions/'
[10:43:53 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/collations/'
[10:43:53 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/extensions/'
[10:43:53 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/sequences/'
[10:43:54 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/datatypes/'
[10:43:56 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/functions/'
[10:43:56 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/208/schemas/209/materializedviews/'
[10:48:07 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/'
[10:48:10 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/206/'
[10:48:12 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/'
[10:48:13 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/'
[10:48:14 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/tables/'
[10:48:16 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/views/'
[10:48:17 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/datatypes/'
[10:48:18 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/sequences/'
[10:48:19 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/extensions/'
[10:48:20 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/collations/'
[10:48:20 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/triggerfunctions/'
[10:48:20 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/procedures/'
[10:48:21 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/functions/'
[10:48:21 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/materializedviews/'
[10:48:28 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/tables/'
[10:48:39 AM] [ObjectExplorerService] [All]: Getting children for node '/tablespaces/'
[10:48:40 AM] [ObjectExplorerService] [All]: Getting children for node '/roles/'
[10:48:41 AM] [ObjectExplorerService] [All]: Getting children for node '/systemdatabases/'
[11:04:24 AM] [ObjectExplorerService] [All]: Getting root OE nodes
[11:04:24 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent)
[11:04:24 AM] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://root@127.0.0.1:26257:concat_test/'
[11:04:27 AM] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://root@127.0.0.1:26257:concat_test/'
[11:04:27 AM] Connecting to server "127.0.0.1" on document "objectexplorer://root@127.0.0.1:26257:concat_test/".
[11:04:27 AM] Connected to server "127.0.0.1" on document "objectexplorer://root@127.0.0.1:26257:concat_test/". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"13.0.0"}
[11:04:27 AM] [ObjectExplorerService] [All]: Getting root OE nodes
[11:04:27 AM] [PgToolsService Initialization] [Verbose]: readAllConnections: 1 connections; excluded recent)
[11:04:27 AM] [ObjectExplorerService] [All]: Getting children for node 'objectexplorer://root@127.0.0.1:26257:concat_test/'
[11:04:28 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/'
[11:04:29 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/'
[11:04:30 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/'
[11:04:31 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/'
[11:04:32 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/views/'
[11:04:33 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/105/tables/'
[11:04:37 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/206/'
[11:04:38 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/206/schemas/'
[11:04:39 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/206/schemas/system/'
[11:04:41 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/631/'
[11:04:43 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/'
[11:04:43 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/'
[11:04:44 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/system/'
[11:04:45 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/309/'
[11:04:46 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/308/schemas/309/tables/'
[11:04:51 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/631/schemas/'
[11:06:50 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/'
[11:06:51 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/'
[11:06:53 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/103/'
[11:06:54 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/103/tables/'
[11:06:56 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/103/tables/'
[11:07:10 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/103/tables/'
[11:07:18 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/4294967295/'
[11:07:19 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/102/schemas/4294967295/tables/'
[11:07:22 AM] [ObjectExplorerService] [All]: Getting children for node '/tablespaces/'
[11:07:28 AM] [PgToolsService Initialization] [Information]: Target is pg version undefined
[11:07:28 AM] [PgToolsService Initialization] [Information]: Found binary versions:  - {}
[11:07:40 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/'
[11:07:42 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/4294966965/'
[11:07:43 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/4294966965/tables/'
[11:07:44 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/4294967095/'
[11:07:45 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/4294967095/tables/'
[11:07:46 AM] [ObjectExplorerService] [All]: Getting children for node '/databases/104/schemas/system/4294967182/'
[11:07:59 AM] Connecting to server "127.0.0.1" on document "schemadesigner://root@127.0.0.1:26257:concat_set/".
[11:07:59 AM] Connected to server "127.0.0.1" on document "schemadesigner://root@127.0.0.1:26257:concat_set/". Server information: {"isCloud":false,"server":"PostgreSQL","serverVersion":"13.0.0"}
[11:07:59 AM] [PgToolsService Initialization] [Error]: Error: Error fetching db context: unknown function: pg_total_relation_size()

Ngôn ngữ chính: Không có dữ liệu ngôn ngữ
Star: 395
Fork: 33
Merge trung bình: 1 giờ 46 phút
Pull request đã merge (30 ngày): 3

Hướng dẫn đóng góp

Chưa lập chỉ mục được hướng dẫn đóng góp cho kho mã nguồn này

Bắt đầu từ đâu

Đọc hết issue, rồi đọc hướng dẫn đóng góp của dự án.
Bình luận trên issue rằng bạn sẽ nhận — tránh hai người làm cùng một việc.
Fork repository và làm thay đổi trên một nhánh.
Mở pull request có tham chiếu số hiệu của issue.

Issue khác của microsoft/vscode-pgsql

Highlight NULL values with yellow background in query result cells for better visibility Đang mở

enhancement

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 68/100

microsoft/vscode-pgsql#190 · 3 bình luận · Mở ngày 20/11/2025
Signature verification failed with 'UnknownError' error. Đang mở

Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 35/100

microsoft/vscode-pgsql#307 · Mở ngày 13/9/2026
Support schema selection through PgBouncer without startup `options` Đang mở

Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 55/100

microsoft/vscode-pgsql#306 · Mở ngày 10/9/2026
Query History crashes after VS Code reload Đang mở

Độ khó 3/5 1-2 ngày Mức phù hợp với người mới 68/100

microsoft/vscode-pgsql#305 · 2 bình luận · Mở ngày 9/9/2026
[Enhancement] Add more context menu options Đang mở

Độ khó 4/5 3-5 ngày Mức phù hợp với người mới 48/100

microsoft/vscode-pgsql#302 · Mở ngày 2/9/2026

Tất cả issue của microsoft/vscode-pgsql

Issue tương tự

[InvoiceShelf] No database info Đang mở

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 68/100

community-scripts/ProxmoxVE#17396 · 1 bình luận · Mở ngày 21/9/2026
[Bounty proposal] fix(backend): clearing one chat deletes every chat file on the account ($25 proposed) Đang mở

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 78/100

BasedHardware/omi#15274 · 3 bình luận · Mở ngày 20/9/2026
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Đang mở

bug

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 90/100

coder/coder#29623 · 1 bình luận · Mở ngày 20/9/2026
`Factbase::Accum#[]` puts the accumulated values before the fact's own ones when `pass` is false and after them when it is true Đang mở

Độ khó 1/5 Dưới một giờ Mức phù hợp với người mới 90/100

yegor256/factbase#1060 · Mở ngày 20/9/2026
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Đang mở

bug database-provider good first issue hacktoberfest

Độ khó 2/5 1-3 giờ Mức phù hợp với người mới 90/100

libredb/libredb-studio#1030 · 6 bình luận · Mở ngày 20/9/2026

Thêm issue về Databases