The community members are discussing issues with the CRUD (Create, Read, Update, Delete) methods on the VectorStoreIndex when using a PGVectorStore. One community member notes that the delete method works using the ref_doc_id, but another community member is encountering an error when trying to use the delete_ref_doc method, stating that the ref_doc_id expects a string, not a number. The community members suggest checking the delete method implementation and providing a more complete traceback to help diagnose the issue. Another community member mentions that the refresh method may not work as intended without additional configuration. In the end, the community member who was experiencing the issue was able to resolve it by creating a simple example, but does not provide a clear answer or solution.
I keep getting an "Error occured on delete of document. ID: 0. Error: %d format: a number is required, not str". And I am using the newer method calls like delete_ref_doc(ref_doc_id=doc_id)
Refresh won't work without some extra TLC to work as intended (it requires enabling/using the docstore, which is disabled for most vectordb integrations)
If I use the simple vec store same code works fine... I'll create simple example using the pgvec example code and see if I get the same thing. The delte does look straightforward... 😕
