Truncation of char, varchar types - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Truncation of char, varchar types
Date
Msg-id Pine.LNX.4.30.0104092116110.1255-100000@peter.localdomain
Whole thread Raw
Responses Re: Truncation of char, varchar types  (ncm@zembu.com (Nathan Myers))
Re: Truncation of char, varchar types  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Excessively long values are currently silently truncated when they are
inserted into char or varchar fields.  This makes the entire notion of
specifying a length limit for these types kind of useless, IMO.  Needless
to say, it's also not in compliance with SQL.

How do people feel about changing this to raise an error in this
situation?  Does anybody rely on silent truncation?  Should this be
user-settable, or can those people resort to using triggers?

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: "--tuning" compile and runtime option (?)
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Truncation of char, varchar types