Pgvector recipe example error null value in column "id" of relation "recipes" violates not-null constraint

General
, ,
1

I am trying the recipes example of PGVector and getting error
as attached. Below is my code sample

from phi.agent import Agent
from phi.model.groq import Groq
from phi.knowledge.pdf import PDFUrlKnowledgeBase
from phi.vectordb.pgvector import PgVector, SearchType
from phi.embedder.huggingface import HuggingfaceCustomEmbedder

import os
from dotenv import load_dotenv
load_dotenv()

embedder = HuggingfaceCustomEmbedder(api_key='XXXXXXXXXXXXX')
db_url = "postgresql+psycopg://ai:ai@localhost:5532/ai"
knowledge_base = PDFUrlKnowledgeBase(
    urls=["https://phi-public.s3.amazonaws.com/recipes/ThaiRecipes.pdf"],
    vector_db=PgVector(table_name="recipes", db_url=db_url, search_type=SearchType.hybrid, embedder=embedder),
)
# Load the knowledge base: Comment out after first run
knowledge_base.load(recreate=True, upsert=False)

agent = Agent(
    model=Groq(id="llama-3.3-70b-versatile", embedder=embedder),
    knowledge=knowledge_base,
    # Add a tool to read chat history.
    read_chat_history=True,
    show_tool_calls=True,
    markdown=True,
    # debug_mode=True,
)
agent.print_response("How do I make chicken and galangal in coconut milk soup", stream=True)
agent.print_response("What was my last question?", stream=True)

![Screenshot 2025-01-03 190822|690x388](upload://j2dIPKcKxp9B5ittsTwKc1pM16n.png)
2

Hello @sridharratna !

I was not able to replicate this error. Can you please share your phidata and huggingface_hub versions?