[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] Automatic value truncation during update
From:       "Glen Parker" <glenebob () nwlink ! com>
Date:       2002-06-03 18:36:09
[Download RAW message or body]

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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html
[prev in list] [next in list] [prev in thread] [next in thread]