| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | "Doug Fields" <dfields-pg-general(at)pexicom(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR: value too long for type character varying(255) |
| Date: | 2002-05-21 20:24:34 |
| Message-ID: | 20020521162434.60fd83fb.nconway@klamath.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 21 May 2002 12:17:38 -0400
"Doug Fields" <dfields-pg-general(at)pexicom(dot)com> wrote:
> 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?
Is there a reason you can't just use TEXT? It will be stored the same
internally...
But the most obvious way I can think of to do what you're asking is
to define a rule to replace the value inserted with a call to
substring().
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug Fields | 2002-05-21 20:54:10 | Re: ERROR: value too long for type character |
| Previous Message | Stephan Szabo | 2002-05-21 19:22:15 | Re: Mysterious locking problem |