Automatic value truncation during update - Mailing list pgsql-general

From Glen Parker
Subject Automatic value truncation during update
Date
Msg-id 011301c20b2d$8832a710$0b01a8c0@johnpark.net
Whole thread Raw
Responses Re: Automatic value truncation during update  (Doug Fields <dfields-pg-general@pexicom.com>)
List pgsql-general
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?

Glen Parker
glenebob@nwlink.com


pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: SOLVED: invalid type error
Next
From: Jan Wieck
Date:
Subject: Re: invalid type error