Delete Conversation API does not work #43

New Issue

2026-02-15T23:17:01-05:00

yindo commented

2026-02-15 23:17:01 -05:00

Originally created by @GojoSatoruS on GitHub (Nov 28, 2023).

Hello,

I'm trying to run the DELETE API under conversations:
getting the following foreign key reference error:
raise translated_error from error sqlalchemy.exc.IntegrityError: (sqlalchemy.dialects.postgresql.asyncpg.IntegrityError) <class 'asyncpg.exceptions.ForeignKeyViolationError'>: update or delete on table "conversation" violates foreign key constraint "message_conversation_id_fkey" on table "message" DETAIL: Key (id)=(79d87f70-4829-41aa-9043-1b61e7888a74) is still referenced from table "message". [SQL: DELETE FROM conversation WHERE conversation.id = $1::UUID] [parameters: ('79d87f70-4829-41aa-9043-1b61e7888a74',)] (Background on this error at: https://sqlalche.me/e/20/gkpj

Any idea how to resolve this?
I have tried to add cascade ON DELETE but alembic migrations are not updating the tables:

class Conversation(Base):
    messages = relationship("Message", back_populates="conversation", cascade="delete, merge, save-update")
    conversation_documents = relationship(
        "ConversationDocument", back_populates="conversation", cascade="delete, merge, save-update"
    )

Any help would be appreciated.

Originally created by @GojoSatoruS on GitHub (Nov 28, 2023). Hello, I'm trying to run the DELETE API under conversations: getting the following foreign key reference error: ` raise translated_error from error sqlalchemy.exc.IntegrityError: (sqlalchemy.dialects.postgresql.asyncpg.IntegrityError) <class 'asyncpg.exceptions.ForeignKeyViolationError'>: update or delete on table "conversation" violates foreign key constraint "message_conversation_id_fkey" on table "message" DETAIL: Key (id)=(79d87f70-4829-41aa-9043-1b61e7888a74) is still referenced from table "message". [SQL: DELETE FROM conversation WHERE conversation.id = $1::UUID] [parameters: ('79d87f70-4829-41aa-9043-1b61e7888a74',)] (Background on this error at: https://sqlalche.me/e/20/gkpj` Any idea how to resolve this? I have tried to add cascade ON DELETE but alembic migrations are not updating the tables: ``` class Conversation(Base): messages = relationship("Message", back_populates="conversation", cascade="delete, merge, save-update") conversation_documents = relationship( "ConversationDocument", back_populates="conversation", cascade="delete, merge, save-update" ) ``` Any help would be appreciated.

yindo commented

2026-02-15 23:17:02 -05:00