Re: value too long error - Mailing list pgsql-general

From Uwe C. Schroeder
Subject Re: value too long error
Date
Msg-id 200402272316.45130.uwe@oss4u.com
Whole thread Raw
In response to value too long error  ("Rajat Katyal" <rajatk@intelesoftech.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Just don't try to save anything into a field that is too short to store the
value. Doesn't make too much sense, since what doesn't fit into the field
would be cut off anyways. If you need this, have your application either
restrict the input field length or cut the extensive part off before you
store it to the database.


On Friday 27 February 2004 11:00 pm, Rajat Katyal wrote:
> Hi:
>
> Whenever i try to insert the data, size of which is greater than that of
> column datatype size,  I got the exception value too long for.....
>
> However this was not in postgresql7.2.
>
> Can anyone please tell me, is there any way so that i wont get this
> exception. Please help me as soon as possible
>
> Thanks in advance.
>
> Rajat.

- --
    UC

- --
Open Source Solutions 4U, LLC    2570 Fleetwood Drive
Phone:  +1 650 872 2425        San Bruno, CA 94066
Cell:   +1 650 302 2405        United States
Fax:    +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAQEBcjqGXBvRToM4RAv2TAKC8CmB4/pJWSk7H3/RDjn38RxBM4QCeKl/O
CIf6DMxms1Y81DBd/9lHBwY=
=b4bg
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "Rajat Katyal"
Date:
Subject: value too long error
Next
From: Sezai YILMAZ
Date:
Subject: Re: PostgreSQL insert speed tests