Skip to content

Instantly share code, notes, and snippets.

View tomy-kyu's full-sized avatar

Yu-i Tominaga tomy-kyu

View GitHub Profile
@tomy-kyu
tomy-kyu / README.md
Last active December 7, 2025 07:21
Dify 1.8.1 -> 1.9.2 Migration Script

Due to the gRPC migration, it appears that after switching Weaviate to gRPC, the index_node_id returned from the vector database is now being treated as a UUID object rather than a string. This has caused SQLAlchemy to generate UUID-type parameters, and PostgreSQL is failing to perform the type conversion. Consequently, the following error was being output:

Run failed: (psycopg2.errors.UndefinedFunction) operator does not exist: character varying = uuid
LINE 1: ...T_TIMESTAMP WHERE document_segments.index_node_id = 'c6f0cc1...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.