Truncation of char, varchar types

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Truncation of char, varchar types
Дата
Msg-id Pine.LNX.4.30.0104092116110.1255-100000@peter.localdomain
обсуждение исходный текст
Ответы Re: Truncation of char, varchar types  (ncm@zembu.com (Nathan Myers))
Re: Truncation of char, varchar types  (The Hermit Hacker <scrappy@hub.org>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: "--tuning" compile and runtime option (?)
Следующее
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: Truncation of char, varchar types