Unable to switch to vectorChord from pgvecto.rs

Hey team, hope you're doing great.

I am trying to follow the guide to migrate from pgvecto.rs to vectorChord, and I'm unable to run the following commands

ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE real[];
ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[];

ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE real[];
ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[];

and it says

ERROR: operator class "vectors.vector_cos_ops" does not accept data type real[]

ERROR: operator class "vectors.vector_cos_ops" does not accept data type real[]

which looks like a valid error and I can't think of a workaround as it looks like pgvecto restricts that column to only be a

vector

vector

type.

Am i missing something here? Please feel free to mention if further information is needed. For some basic info

postgres version: 14.18
vectorChord version: 0.3.0
Immich version: I'm updating from 1.123.0 to 1.133.0

Thanks in advance. Any suggestions are appreciated.

Immich•9mo ago•

9 replies

P S Solanki

Unable to switch to vectorChord from pgvecto.rs

Hey team, hope you're doing great.

I am trying to follow the guide to migrate from pgvecto.rs to vectorChord, and I'm unable to run the following commands

ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE real[];
ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[];

ALTER TABLE smart_search ALTER COLUMN embedding SET DATA TYPE real[];
ALTER TABLE face_search ALTER COLUMN embedding SET DATA TYPE real[];

and it says

ERROR: operator class "vectors.vector_cos_ops" does not accept data type real[]

ERROR: operator class "vectors.vector_cos_ops" does not accept data type real[]

which looks like a valid error and I can't think of a workaround as it looks like pgvecto restricts that column to only be a

vector

vector

Unable to switch to vectorChord from pgvecto.rs

Similar Threads

Unable to switch to vectorChord from pgvecto.rs

Similar Threads

Similar Threads

Similar Threads