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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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