Enable pgvector extension

TL;DR

Verified on Neon: pgvector 0.8.6 enabled, migration recorded in drizzle.__drizzle_migrations, and '[1,0]'::vector [=] '[0,1]'::vector = 1.

Fix

1. Verified on Neon: pgvector 0.8.6 enabled, migration recorded in drizzle.__drizzle_migrations, and '[1,0]'::vector [=] '[0,1]'::vector = 1. Expected: you can confirm this matches your situation.

When to use

• You are dealing with this situation.
• The symptom matches: Enable pgvector extension.

When NOT to use

• Unrelated issues with a different cause.
• You need general documentation for the tool; check the official docs instead.

Compatibility

Reported per the linked source (mentions 0.8.6). Source: GitHub issue: https://github.com/aniketmandloi/anything-tonight/issues/5.

Variant phrasings

Enable pgvector extension

Why it happens

GitHub issue aniketmandloi/anything-tonight#5 (closed, 2 comments, reported 2026-09-24): ## Goal Vector column support for embeddings and mood vectors. ## Scope - Migration CREATE EXTENSION IF NOT EXISTS vector ## Acceptance criteria - [ ] Extension present in DB ## Verification select * from pg_extension where extname='vector' returns a row. ## Depends on #4 Work in small atomic commits referencing this issue. See docs/PLAN.md.

Edge cases

• If your error message differs even slightly, this is probably a different issue; search the exact text.
• Behavior can change between releases; the linked source reflects the versions above.
• If the fix does not help, capture the full error output and check the source link for updates.

Source

GitHub issue: https://github.com/aniketmandloi/anything-tonight/issues/5

Source: GitHub issue aniketmandloi/anything-tonight#5 (closed, 2 comments, reported 2026-09-24): ## Goal Vector column support for embeddings and mood vectors. ## Scope - Migration CREATE EXTENSION IF NOT EXISTS vector ## Acceptance criteria - [ ] Extension present in DB ## Verification select * from pg_extension where extname='vector' returns a row. ## Depends on #4 Work in small atomic commits referencing this issue. See docs/PLAN.md.

Verified resolution: [aniketmandloi]: Verified on Neon: pgvector 0.8.6 enabled, migration recorded in drizzle.__drizzle_migrations, and '[1,0]'::vector [=] '[0,1]'::vector = 1.

Source URL: https://github.com/aniketmandloi/anything-tonight/issues/5