Postgres PGVector Store

[JBomNotilyze]

Bug Description

The Postgres PGVector Store imports the langchain_community.vectorstores.pgvector.PGVector object, with the default parameter create_extension=True. This requires admin privilages, which not all users should have, resulting in the error (even if the extension is already installed):

"""Because vector isn't a trusted extension, only members of "azure_pg_admin" are allowed to use CREATE EXTENSION vector"""

Please add an option to disable the automatic creation of the extension in the n8n node.

To Reproduce

Add a non-admin user to your postgres database, and try to use any of the Postgres PGVector Store functionalities as this user.

Expected behavior

To be able to use a Postgres database as a Vector Store within n8n.

Operating System

n8n cloud

n8n Version

1.89.2

Node.js Version

?

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @JBomNotilyze,

We have created an internal ticket to look into this which we will be tracking as "GHC-2189"