Open mkrug1981 opened 5 years ago
Indexing is - I think - how we maintain uniqueness. That could be changed to a constraint, but I think the other hints it gives about indexing a hash or "use[ing] full-text indexing" are worth looking into.
if the intent is to limit parameter values to 2712 characters, better validation is needed in TO.
The constraint was added in https://github.com/apache/trafficcontrol/commit/994f6f6594f2. Maybe it was intended as a solution to needing 2 parameters with the same name but different content?
If so, the constraint does not seem helpful and should be dropped entirely.
I'm submitting a ...
Traffic Control components affected ...
Current behavior:
Creating a parameter with a large text value causes following postgres database error.
Expected / new behavior:
Possibility to store large text values, like complex lua code files as parameter without errors. Not sure but disabling indexing for the text field might help?
Minimal reproduction of the problem with instructions:
Create a parameter with a text value with more as 2800 characters will trigger the issue.
Anything else:
Some database details output for the tables and parameter settings