Foreign key issue while attempting to delete workspace
Windmill version: self hosted CE v1.206.0-7
The PG database is the one provided with the docker compose setup (which I didn't update since I first installed windmill though)
I attempted to delete a windmill workspace but was greeted with foreign key constraint violation errors.
As I was in a hurry I fixed it myself by deleting manually the following rows (where WK_ID is the id of the workspace I wanted to delete)
DELETE FROM queue WHERE workspace_id = 'WK_ID'
DELETE FROM capture WHERE workspace_id = 'WK_ID'
DELETE FROM draft WHERE workspace_id = 'WK_ID'
After I ran this queries I was able to proceed with proper deletion of the workspace.
The PG database is the one provided with the docker compose setup (which I didn't update since I first installed windmill though)
I attempted to delete a windmill workspace but was greeted with foreign key constraint violation errors.
As I was in a hurry I fixed it myself by deleting manually the following rows (where WK_ID is the id of the workspace I wanted to delete)
DELETE FROM queue WHERE workspace_id = 'WK_ID'
DELETE FROM capture WHERE workspace_id = 'WK_ID'
DELETE FROM draft WHERE workspace_id = 'WK_ID'
After I ran this queries I was able to proceed with proper deletion of the workspace.
