fix(postgres): drop text enum check constraints only when necessary

[B4nan]

Closes #4112

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 99.69%. Comparing base (c2843b9) to head (76b60b9).

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #5414      +/-   ##
==========================================
- Coverage   99.71%   99.69%   -0.03%     
==========================================
  Files         222      222              
  Lines       17116    17125       +9     
  Branches     3684     4211     +527     
==========================================
+ Hits        17067    17072       +5     
- Misses         49       52       +3     
- Partials        0        1       +1     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.