Re: value too long error

Ya, through application we can provide field input validation but iam working on the tool which transfers the data from some specifed database to another. Here user itself wants if value is too long for the target column then truncates the text and insert into the target field. It was there in postgres version 7.2 but not in postgres 7.3.

At database level how can we provide a check if text size is greater than that of field size then truncate it?

Thanks and Regards,
Rajat.

----- Original Message -----
From: "Uwe C. Schroeder" <uwe(at)oss4u(dot)com>
To: "Rajat Katyal" <rajatk(at)intelesoftech(dot)com>; <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, February 28, 2004 12:46 PM
Subject: Re: [GENERAL] value too long error

> -----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-----
>