"Eric Jain" <Eric(dot)Jain(at)isb-sib(dot)ch> writes:
> The main reason why I am still using VARCHAR rather than TEXT in many
> places is to ensure that the column can be indexed. Postgres, it seems,
> refuses to insert a string that is longer than some value into an
> indexed column, and I'll rather have such errors flagged while inserting
> a row rather than while rebuilding an index after having inserted lots
> of rows.
This is bogus reasoning. The limit on index entry length will not
change when you rebuild the index.
regards, tom lane