Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)

There are very few situations where a non-arbitrary free-form text field is going to have a non-arbitrary length constraint - that is also immutable.  Generally, spending time to figure out those rare exceptions is wasted effort better spent elsewhere.  They are also mostly insufficient when used for their typical "protection" purpose.  If you really want protection add well thought out constraints.

Its less problematic now that increasing the generally arbitrary length doesn't require a table rewrite but you still need to rebuild dependent objects.

David J.