microsoft / microsoft/vscode-pgsql
does not exist CONTEXT: SQL function "has_database_privilege"
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
Can successfully connect to the service but cannot list the database.
To Reproduce
Steps to reproduce the behavior:
- Connect to the service
- list the database
Expected behavior
The database should be listed correctly without errors.
Screenshots
VS Code version
Version: 1.100.2
Commit: 848b80aeb52026648a8ff9f7c45a9b0a80641e2e
Date: 2025-05-14T21:47:40.416Z
Electron: 34.5.1
ElectronBuildId: 11369351
Chromium: 132.0.6834.210
Node.js: 20.19.0
V8: 13.2.152.41-electron.0
OS: Darwin arm64 24.4.0
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the issue through the VS Code PostgreSQL extension: connect to the service and attempt to list databases, using the reported VS Code 1.100.2 environment as context. Investigate where the database-listing request invokes the PostgreSQL has_database_privilege function. Done means the database list loads without the reported SQL-function error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, vscode
- Domain
- databases, devtools
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100