Skip site navigation (1) Skip section navigation (2)

Re: value too long error

From: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>
To: "Rajat Katyal" <rajatk(at)intelesoftech(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: value too long error
Date: 2004-02-28 07:16:42
Message-ID: 200402272316.45130.uwe@oss4u.com (view raw or flat)
Thread:
Lists: 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-----


In response to

Responses

pgsql-general by date

Next:From: Sezai YILMAZDate: 2004-02-28 08:29:56
Subject: Re: PostgreSQL insert speed tests
Previous:From: Rajat KatyalDate: 2004-02-28 07:00:25
Subject: value too long error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group