value too long for type character varying(25)

From: Frank Yip <frankyip(at)nasitron(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: value too long for type character varying(25)
Date: 2002-11-18 16:23:19
Message-ID: 3DD913F7.442E7FC4@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, I got this error after I upgraded to 7.2.1
I found the document from the below link.

http://www.postgresql.org/idocs/index.php?datatype-character.html

which say "Prior to PostgreSQL 7.2, strings that were too long were
silently truncated, no error was raised."

does anyone know if there is a option to set it truncate the strings?

Thanks alot.

Frank

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Pucher 2002-11-18 21:43:31 sort case insensitive
Previous Message Henshall, Stuart - Design & Print 2002-11-18 10:15:45 Re: run shell command from pl/pgsql