rob05c edited a comment on issue #4038: TP, TO: server capabilities are allowed to be assigned to any servers which are not mid or edge URL: https://github.com/apache/trafficcontrol/issues/4038#issuecomment-547493652 Eh, you're right. Postgres check constraints can't reference other tables (the pattern is easy, they do support regexes, it's the other table that's hard). It's possible with a trigger. But I'm on the fence whether the ugliness and pain of a trigger/function is worth it. Of course, this wouldn't even be an issue if our data was properly normalized, and the server table wasn't overloaded for multiple types.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services