problem with building models in postgres

[aolin118]

add text() to several query in models.py and I met below problems

💽 Building models in Postgres ..

wait-for-it.sh: waiting 60 seconds for db:5432 to be available (tcp)
wait-for-it.sh: db:5432 is available after 0 seconds
INFO:config:...Enabling pgvector and creating database tables
...Enabling pgvector and creating database tables
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)

psycopg2.errors.InvalidParameterValue: dimensions for type vector cannot exceed 1024

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/app/api/models.py", line 665, in
create_db()
File "/app/api/models.py", line 588, in create_db
enable_vector()
File "/app/api/models.py", line 625, in enable_vector
add_vector_distance_fn(session)
File "/app/api/models.py", line 658, in add_vector_distance_fn
session.exec(query)
File "/usr/local/lib/python3.9/site-packages/sqlmodel/orm/session.py", line 68, in exec
results = super().execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2308, in execute
return self._execute_internal(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2199, in _execute_internal
result = conn.execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1416, in execute
return meth(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 516, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1639, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1848, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1988, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 2343, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1969, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 922, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.InvalidParameterValue) dimensions for type vector cannot exceed 1024

[SQL: create or replace function match_node_euclidean (
query_embeddings vector(1536),
match_threshold float,
match_count int
) returns table (
uuid uuid,
text varchar,
similarity float
)
language plpgsql
as $$
begin
return query
select
node.uuid,
node.text,
1 - (node.embeddings <-> query_embeddings) as similarity
from node
where 1 - (node.embeddings <-> query_embeddings) > match_threshold
order by similarity desc
limit match_count;
end;
$$;]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
make[1]: *** [models] Error 1
make: *** [install] Error 2