Prisma•6mo ago

Enabling `vector` in Prisma Postgres DB

I'm trying to enable pgvector in prisma postgres. Be it via running migration script or connecting to the db and executing the command: CREAT EXTENSION vector; it does not work. Instead, I just get this error:

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

ERROR: extension "vector" is not available
DETAIL: Could not open extension control file "/usr/local/share/postgresql/extension/vector.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

6 Replies

Prisma AI Help•6mo ago

You selected the carefully hand-crafted route. A dev artisan will respond soon. Meanwhile, the #ask-ai channel awaits if you're curious!

jonfanz•6mo ago

Last I heard extensions couldn’t be enabled in Prisma Postgres

Nurul•6mo ago

Hello! Jon is correct. pgvector extension isn't supported by prisma postgres yet. We are working on adding support for more extensions very soon. https://www.prisma.io/docs/postgres/more/known-limitations#limited-postgres-extensions-support

Ankur Datta•4mo ago

Hey @aith 👋🏾 , Prisma Postgres now has pgvector extension support, along with a few other extensions. You can see an implementation example in the launch article here. Give it a try and let us know if you have any feedback 🙏🏾 !

Prisma

ORM 6.13.0, CI/CD Workflows & pgvector for Prisma Postgres

Prisma ORM v6.13.0 introduces Prisma Config & multi-schema support in GA, pgvector for Prisma Postgres, a new Management API for CI/CD, SQL view enhancements, and a redesigned Prisma Console UI.

aithOP•4mo ago

Just what I needed! Amazing. I'm gonna try it out tonight

Ankur Datta•4mo ago

Awesome!

Gaming

Programming

Enabling `vector` in Prisma Postgres DB

Did you find this page helpful?