hammadsaleemm opened a new issue, #939: URL: https://github.com/apache/age/issues/939
I have a graph database where I want to delete specific edges while retaining the corresponding vertices. Currently, I'm using constraints to ensure data integrity and maintain referential integrity between the vertices and edges. My database schema includes two tables: vertices and edges. The vertices table represents the vertices in the graph, and the edges table represents the edges connecting those vertices. I'm using foreign key constraints between the edges table and the vertices table. The issue I'm facing is that when I delete an edge, the associated vertices are also deleted due to the cascading behavior defined in the constraints. However, I would like to retain the vertices even after deleting the edges. Is there a way to modify the constraints or define new constraints in such a way that the vertices are not deleted when deleting the edges? I want to ensure that the vertices remain in the database, even if they are not connected to any edges. Any guidance, suggestions, or code examples would be highly appreciated. Thank you! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
