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

From The Hermit Hacker
Subject Re: Truncation of char, varchar types
Date
Msg-id Pine.BSF.4.33.0104091627290.72136-100000@mobile.hub.org
Whole thread Raw
In response to Truncation of char, varchar types  (Peter Eisentraut <peter_e@gmx.net>)
List 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 by date:

Previous
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Truncation of char, varchar types
Next
From: John Coers
Date:
Subject: libpq PQexec call of COPY