Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Webapp: Route deletions cannot be done without removing entries from route_upstream #38

Open
saarasio opened this issue Sep 17, 2019 · 0 comments

Comments

@saarasio
Copy link
Owner

Route id is a foreign key in route_upstream relationship table. Entry in this table should be deleted before the route is deleted.

When a route delete call is made, we could first delete the entries from route_upstream table.

9b1dd9:~ v3$ curl -s -X DELETE https://ingresspipe.io:8443/service/adminservice2/route/db_requests -H "Authorization: Bearer treehugger" | python -m json.tool
{
    "errors": [
        {
            "extensions": {
                "code": "constraint-violation",
                "path": "$"
            },
            "message": "Foreign key violation. update or delete on table \"route\" violates foreign key constraint \"route_upstream_route_id_fkey\" on table \"route_upstream\""
        }
    ]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant