FabsOriginal post
Web Developer
I had defined a two-way relationship between 2 tables, then I deleted the relationship column
I tried re-creating the column but I started to get errors about the column already existing, although it wasn't present in the columns list in the cloud console.
```
$ appwrite tables-db get-column --database-id="6978c6f5001c76c8ec40" --table-id="listings"--key="medias"
key : medias
type : string
status : stuck
error : Cannot delete relationship as an attribute
required : false
Plain text
When I tried to update the relationship column to a new name got this:```$ appwrite tables-db update-relationship-column --database-id="6978c6f5001c76c8ec40" --table-id="listings" --key="medias" --new-key="medias_delete" --verboseAppwriteException: The requested column '%s' is not yet available. Please try again later. at _Client.<anonymous> (/opt/homebrew/Cellar/appwrite/13.1.0/libexec/lib/node_modules/appwrite-cli/dist/cli.cjs:110478:15) at Generator.next (<anonymous>) at fulfilled (/opt/homebrew/Cellar/appwrite/13.1.0/libexec/lib/node_modules/appwrite-cli/dist/cli.cjs:109833:24) at process.processTicksAndRejections (node:internal/process/task_queues:104:5) { code: 400, type: 'column_not_available', response: `{"message":"The requested column '%s' is not yet available. Please try again later.","code":400,"type":"column_not_available","version":"1.8.1"}`}✗ Error: The requested column '%s' is not yet available. Please try again later.```
There was also a row with the relationship column with a value, after deleting the column I am not able to delete that row.```✗ Error: response: '{"message":"Server Error","code":500,"type":"general_unknown","version":"1.8.1"}'}```Summary
Developers are experiencing issues when trying to delete a relationship column that still shows as 'stuck.' Even after attempting to update the column name, errors persist. A row with a relationship column value cannot be deleted. This requires a potentially complex solution and might involve a bug report to the platform provider.