[BUG] Option 4 - Manual Setup: Drizzle push fails without vector extension due to not being mentioned in docs

[Shayan12456]

Describe the bug
Currently, there's no mention in the documentation that the vector extension must be enabled manually in PostgreSQL for Drizzle to work correctly when using vector types. Before Drizzle push running this should be mentioned CREATE EXTENSION IF NOT EXISTS vector;

To Reproduce
Steps to reproduce the behavior:

1. Set up the project and database following the documentation [Option 4: Manual Setup]
2. Run bunx drizzle-kit push
3. See error: PostgresError: type "vector" does not exist

Expected behavior
The drizzle-kit push command should work without error, assuming the database is correctly set up. The docs should instruct users to run:

Screenshots

[yusrimathews]

@Shayan12456 any interim workaround for this?

[kprocks86]

@yusrimathews the workaround is already in the bug that is posted CREATE EXTENSION IF NOT EXISTS vector; if you have vector enabled on postgres.

[waleedlatif1]

@Shayan12456 @yusrimathews @kprocks86 let me know if anyone is still having issues, but added instructions to the docs for option 4