ocket8888 commented on issue #3870: Rewrite /capabilities to Go
URL: https://github.com/apache/trafficcontrol/pull/3870#issuecomment-521713196
 
 
   > _"If you update the name of a capability does it automatically update all 
the FK references in the api_capabilities table?"_
   
   It can, depends if the foreign key constraint was defined with `ON UPDATE 
CASCADE`. Which it should have been. But looking at 
`traffic_ops/app/db/create_tables.sql` it was not. Adding that clause is simple 
enough - and should be done, IMO -, but it's a database migration, so I'm not 
sure it's proper to include it in what's already a pretty expansive PR.
   
   Extensions certainly have access to the database at runtime, but idk if they 
do at startup.

----------------------------------------------------------------
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

Reply via email to