Revert "fix pg_vector extension requires SUPERUSER, but not availabl… (langgenius#24108)

crazywoola · web-flow · commit 8288b1dcab97 · 2025-08-18T16:46:15.000+08:00
diff --git a/api/configs/middleware/vdb/pgvector_config.py b/api/configs/middleware/vdb/pgvector_config.py
@@ -9,11 +9,6 @@ class PGVectorConfig(BaseSettings):
     Configuration settings for PGVector (PostgreSQL with vector extension)
     """
 
-    PGVECTOR_IS_OWNER: Optional[bool] = Field(
-        description="Whether the PGVector is the owner of the database",
-        default=True,
-    )
-
     PGVECTOR_HOST: Optional[str] = Field(
         description="Hostname or IP address of the PostgreSQL server with PGVector extension (e.g., 'localhost')",
         default=None,
diff --git a/api/core/rag/datasource/vdb/pgvector/pgvector.py b/api/core/rag/datasource/vdb/pgvector/pgvector.py
@@ -253,8 +253,7 @@ def _create_collection(self, dimension: int):
                 return
 
             with self._get_cursor() as cur:
-                if dify_config.PGVECTOR_IS_OWNER:
-                    cur.execute("CREATE EXTENSION IF NOT EXISTS vector")
+                cur.execute("CREATE EXTENSION IF NOT EXISTS vector")
                 cur.execute(SQL_CREATE_TABLE.format(table_name=self.table_name, dimension=dimension))
                 # PG hnsw index only support 2000 dimension or less
                 # ref: https://github.com/pgvector/pgvector?tab=readme-ov-file#indexing
