GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — PostgreSQL online store ignores database search_path, breaking extensions like pgvector · Issue #5814 · feast-dev/feast

PostgreSQL online store ignores database search_path, breaking extensions like pgvector #5814

New issue
Copy link
New issue
Copy link
Closed
#5970
Closed
PostgreSQL online store ignores database search_path, breaking extensions like pgvector#5814
#5970
Copy link
Assignees
Anarion-zuo
Labels
kind/bugpriority/p2

Description

@max36067
max36067
opened on Jan 5, 2026
Issue body actions

Expected Behavior

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

  1. Install pgvector extension in PostgreSQL:
    CREATE EXTENSION vector; -- installs to public by default
  2. Configure feature_store.yaml with a custom schema:
    online_store:
    type: postgres
    db_schema: feast_online
    vector_enabled: true
  3. Run feast apply
  4. Error occurs:
    psycopg.errors.UndefinedObject: type "vector" does not exist
    LINE 8: vector_value vector NULL,

Specifications

  • Version: 0.58.0
  • Platform: macOS / Linux
  • Subsystem: PostgreSQL

Activity

  1. max36067
    added
    kind/bug
    priority/p2
    on Jan 5, 2026
  2. max36067 commented on Jan 22, 2026

    @max36067
    max36067
    on Jan 22, 2026
    Author
    More actions

    And it also reject by PgBouncer transaction pooling mode.

  3. Anarion-zuo commented on Feb 12, 2026

    @Anarion-zuo
    Anarion-zuo
    on Feb 12, 2026
    Contributor
    More actions

    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.

  4. ntkathole
    assigned
    Anarion-zuo
    on Feb 15, 2026
  5. ntkathole
    closed this as completedin #5970on Feb 15, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

  • @Anarion-zuo
    Anarion-zuo

Labels

kind/bugpriority/p2

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

    You are visitor 01402503 — GeezerVison does not store the pages you look up.
    Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.