Re: Automatic value truncation during update

At 02:36 PM 6/3/2002, Glen Parker wrote:
>Postgres 7.1.* and before I believe would silently truncate values to
>fit into their destination fields during insert/update, but 7.2.* gives
>an error when values are too long. I realize the new behavior is
>probably more correct, but I grew accustom to the old behavior and now
>have queries that rely on that behavior, for better or worse. I don't
>see a way to get pgsql to use the old behavior. Am I missing it or is
>it really not there?

Having just gone through this: It's really not there.

Check the archives for the last month or two for all the work-arounds
suggested. The easy way out is to use TEXT fields.

Cheers,

Doug