Re: Truncation of char, varchar types

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: Truncation of char, varchar types
Дата
Msg-id Pine.BSF.4.33.0104091627290.72136-100000@mobile.hub.org
обсуждение исходный текст
Ответ на Truncation of char, varchar types  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
After v7.1 is released ... ?

On Mon, 9 Apr 2001, Peter Eisentraut wrote:

> 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/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org



В списке pgsql-hackers по дате отправления:

Предыдущее
От: ncm@zembu.com (Nathan Myers)
Дата:
Сообщение: Re: Truncation of char, varchar types
Следующее
От: John Coers
Дата:
Сообщение: libpq PQexec call of COPY