Postgres Pro
Downloads
Home   >   mailing lists

ERROR: value too long for type character varying(255) - Mailing list pgsql-general

From Doug Fields
Subject ERROR: value too long for type character varying(255)
Date
Msg-id 5.1.0.14.2.20020521121522.02a91088@mail.pexicom.com
Whole thread Raw
In response to Re: PostgreSQL 7.1 forces sequence scan when there is no reason  (Denis Perchine <dyp@perchine.com>)
Responses Re: ERROR: value too long for type character varying(255)
List pgsql-general
Tree view 
Hello again,

In PG 7.1.3, ISTR I used to be able to submit any length I wished for a
VARCHAR (and maybe a CHAR).

Now, I'm at 7.2.1 and get these errors:

ERROR:  value too long for type character varying(255)

as JDBC Exceptions.

Do you know how I can tell it to "silently truncate" the data as I believe
it used to?

Many thanks,

Doug

PS: This group is great, and some of you (you know who you are) are amazing.

pgsql-general by date:

Previous
From: "Olonichev Sergei"
Date:
Subject: Re: data addition speed or how to fast add data?
Next
From: Tom Jenkins
Date:
Subject: Update and Insert in a View Insert Rule