You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
PostgreSQL online store ignores database search_path, breaking extensions like pgvector #5814
When vector_enabled: true is configured and the pgvector extension is installed in the database (in public schema), Feast should be able to create tables with vector columns. The database's configured search_path should be respected.
Current Behavior
Feast fails with psycopg.errors.UndefinedObject: type "vector" does not exist because it hardcodes the connection search_path to only the db_schema value, excluding public where extensions are typically installed:
# feast/infra/utils/postgres/connection_utils.py#L76
"options": "-c search_path={}".format(config.db_schema or config.user),
This overrides any database or user-level search_path settings.
Steps to Reproduce
Install pgvector extension in PostgreSQL:
CREATE EXTENSION vector; -- installs to public by default
Configure feature_store.yaml with a custom schema:
online_store:
type: postgres
db_schema: feast_online
vector_enabled: true
Run feast apply
Error occurs:
psycopg.errors.UndefinedObject: type "vector" does not exist
LINE 8: vector_value vector NULL,
Hi team. I ran into a similar issue, and already came up with a solution. I can publish the solution as a PR in a few days. Please assign this issue to me, if you would allow it.
Activity
max36067 commentedon Jan 22, 2026
And it also reject by PgBouncer transaction pooling mode.
Anarion-zuo commentedon Feb 12, 2026
Hi team. I ran into a similar issue, and already came up with a solution. I can publish the solution as a PR in a few days. Please assign this issue to me, if you would allow it.