bug: install at schema would fail at create index

[cutecutecat]

Now we could not install pgvector.rs at schema.

CREATE SCHEMA tschema;
CREATE EXTENSION vectors WITH SCHEMA tschema;

CREATE TABLE tschema.t (val tschema.vector(3));
INSERT INTO tschema.t (val) SELECT ARRAY[random(), random(), random()]::real[] FROM generate_series(1, 1000);

CREATE INDEX native_index ON tschema.t USING vectors (val tschema.vector_cos_ops)
WITH (options = "[indexing.hnsw]");
ERROR:  type "vector" does not exist

Related function:

• pgrx::wrappers::regtypein("vector")
• regoperatorin("<#>(vector,vector)")

[usamoi]

ref: https://www.postgresql.org/docs/current/sql-createextension.html

We can force schema vectors and set search_path to vectors, ... to solve it.

SET COMMAND can be invoked by function. See https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SET.

In this way, we can just use vectors.vector and vectors.<->(vectors.vector,vectors.vector) in our code.