Mintplex-Labs/anything-llm
1
0
Fork 0
mirror of https://github.com/Mintplex-Labs/anything-llm.git synced 2026-07-19 14:13:35 -04:00
Code Issues 328 Packages Projects Releases 10 Wiki Activity

[PR #4430] [MERGED] Add PostgreSQL vector extension in createTableIfNotExists function #4617

New Issue
Closed
opened 2026-02-22 18:36:11 -05:00 by yindo · 0 comments
yindo commented 2026-02-22 18:36:11 -05:00
Owner
Copy Link
Copy Source

📋 Pull Request Information

Original PR: https://github.com/Mintplex-Labs/anything-llm/pull/4430
Author: @angelplusultra
Created: 9/23/2025
Status: ✅ Merged
Merged: 9/25/2025
Merged by: @timothycarambat

Base: master ← Head: 4429-type-vector-does-not-exist

📝 Commits (3)

  • a096e14 Add PostgreSQL vector extension in createTableIfNotExists function
  • 4375160 move extension sql to function
  • dbf8aff Merge branch 'master' into 4429-type-vector-does-not-exist

📊 Changes

1 file changed (+2 additions, -0 deletions)

View changed files

📝 server/utils/vectorDbProviders/pgvector/index.js (+2 -0)

📄 Description

Pull Request Type

  • ✨ feat
  • 🐛 fix
  • ♻️ refactor
  • 💄 style
  • 🔨 chore
  • 📝 docs

Relevant Issues

resolves #4429

What is in this change?

This PR introduces a one line fix to ensure the pgvector extension is enabled on the user's PG database before proceeding with document embedding. This fixes the "type vector does not exist" error.

As stated in the issue, this is happening because by default, a PG database w/ PG Vector does not have the plugin enabled. It must be explicit enabled with the SQL command CREATE EXTENSION vector

Official PG Vector Docs:
https://github.com/pgvector/pgvector?tab=readme-ov-file#getting-started

Additional Information

Developer Validations

  • I ran yarn lint from the root of the repo & committed changes
  • Relevant documentation has been updated
  • I have tested my code functionality
  • Docker build succeeds locally

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/Mintplex-Labs/anything-llm/pull/4430 **Author:** [@angelplusultra](https://github.com/angelplusultra) **Created:** 9/23/2025 **Status:** ✅ Merged **Merged:** 9/25/2025 **Merged by:** [@timothycarambat](https://github.com/timothycarambat) **Base:** `master` ← **Head:** `4429-type-vector-does-not-exist` --- ### 📝 Commits (3) - [`a096e14`](https://github.com/Mintplex-Labs/anything-llm/commit/a096e148159e82606550dd7f495346b1f56d2e01) Add PostgreSQL vector extension in createTableIfNotExists function - [`4375160`](https://github.com/Mintplex-Labs/anything-llm/commit/43751604c0e5307c390158771ab62f76ea6e15d9) move extension sql to function - [`dbf8aff`](https://github.com/Mintplex-Labs/anything-llm/commit/dbf8affbb21da3628965761c34dbbe3befdb6a64) Merge branch 'master' into 4429-type-vector-does-not-exist ### 📊 Changes **1 file changed** (+2 additions, -0 deletions) <details> <summary>View changed files</summary> 📝 `server/utils/vectorDbProviders/pgvector/index.js` (+2 -0) </details> ### 📄 Description ### Pull Request Type <!-- For change type, change [ ] to [x]. --> - [ ] ✨ feat - [x] 🐛 fix - [ ] ♻️ refactor - [ ] 💄 style - [ ] 🔨 chore - [ ] 📝 docs ### Relevant Issues <!-- Use "resolves #xxx" to auto resolve on merge. Otherwise, please use "connect #xxx" --> resolves #4429 ### What is in this change? <!-- Describe the changes in this PR that are impactful to the repo. --> This PR introduces a one line fix to ensure the pgvector extension is enabled on the user's PG database before proceeding with document embedding. This fixes the "type vector does not exist" error. As stated in the issue, this is happening because by default, a PG database w/ PG Vector does not have the plugin enabled. It must be explicit enabled with the SQL command `CREATE EXTENSION vector` Official PG Vector Docs: https://github.com/pgvector/pgvector?tab=readme-ov-file#getting-started ### Additional Information <!-- Add any other context about the Pull Request here that was not captured above. --> ### Developer Validations <!-- All of the applicable items should be checked. --> - [x] I ran `yarn lint` from the root of the repo & committed changes - [x] Relevant documentation has been updated - [x] I have tested my code functionality - [ ] Docker build succeeds locally --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
yindo added the pull-request label 2026-02-22 18:36:11 -05:00
yindo closed this issue 2026-02-22 18:36:11 -05:00
yindo changed title from [PR #4430] Add PostgreSQL vector extension in createTableIfNotExists function to [PR #4430] [MERGED] Add PostgreSQL vector extension in createTableIfNotExists function 2026-06-05 15:19:29 -04:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Desktop
Docker
Integration Request
Integration Request
OS: Linux
OS: Mobile
OS: Windows
UI/UX
blocked
bug
bug
core-team-only
documentation
duplicate
embed-widget
enhancement
feature request
github_actions
good first issue
investigating
needs info / can't replicate
possible bug
pull-request
Mirrored from GitHub Pull Request
 question
stage: specifications
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Mintplex-Labs/anything-llm#4617
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?