Automatic value truncation during update

From: "Glen Parker" <glenebob(at)nwlink(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Automatic value truncation during update
Date: 2002-06-03 18:36:09
Message-ID: 011301c20b2d$8832a710$0b01a8c0@johnpark.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)nwlink(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-06-03 19:10:36 SOLVED: invalid type error
Previous Message Gregory Seidman 2002-06-03 18:32:05 Re: reverse of extract epoch?