drizzle-orm integration cannot generate vector columns

davidgomes commented 4 months ago

If I try to generate a PG table with a column like so:

embedding: vector('embedding', {dimensions: 1536}),

Then, the drizzle-kit generated migration will look like this:

ALTER TABLE "documents" ADD COLUMN "embedding" "vector(1536)";

This is not valid SQL in Postgres, it should be:

ALTER TABLE "documents" ADD COLUMN "embedding" vector(1536);

(Otherwise, you get ERROR: type "vector(1536)" does not exist)

I am not 100% sure if this is an issue with this extension or not, but figured I'd report it here.

ankane commented 4 months ago

Hi @davidgomes, unfortunately, this is a current limitation of Drizzle Kit (docs).

davidgomes commented 4 months ago

Thank you!

gvkhna commented 3 months ago

This has, i believe, finally been addressed.

pgvector / pgvector-node