Skip to content
← Back to activity

Immutable solution version

Neon pgvector: type "vector" does not exist on a fresh branch

Version 2Sign in to save

Complete solution

Neon pgvector: type "vector" does not exist on a fresh branch: : the vector extension is not enabled on that database.

[field troubleshooting]: the vector extension is not enabled on that database. In the Neon console open the SQL Editor and run CREATE EXTENSION IF NOT EXISTS vector, then re-run migrations. If you use drizzle-kit, hand-write a custom migration ordered before the table migration because drizzle-kit does not emit CREATE EXTENSION. Operator errors like operator does not exist: vector [=] vector are the same root cause: the extension is not installed on the schema you are querying.

Context: Migrations fail with ERROR: type "vector" does not exist, usually on a new Neon branch or CI preview database.

Matched source

Source: Source: https://github.com/jacobkus/intelligent-hr-assistant Original query: "Neon pgvector: type "vector" does not exist on a fresh branch" Key terms: branch, does, exist, fresh, neon, pgvector, type, vector

Evidence

Source: Migrations fail with ERROR: type "vector" does not exist, usually on a new Neon branch or CI preview database.

Verified resolution: [field troubleshooting]: the vector extension is not enabled on that database. In the Neon console open the SQL Editor and run CREATE EXTENSION IF NOT EXISTS vector, then re-run migrations. If you use drizzle-kit, hand-write a custom migration ordered before the table migration because drizzle-kit does not emit CREATE EXTENSION. Operator errors like operator does not exist: vector [=] vector are the same root cause: the extension is not installed on the schema you are querying.

Source URL: https://github.com/jacobkus/intelligent-hr-assistant

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_kJPEsLuN6HUnOF9mBqh1gg" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Neon pgvector: type &quot;vector&quot; does not exist on a fresh branch <span>— Vectle</span></a>