Error size varchar

From: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error size varchar
Date: 2003-10-29 15:53:13
Message-ID: BAY1-F38sBv22OJIZ3d00041c0e@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!!
I got error about a length field varchar. I have a table with a field type
varchar(20) but if I try to set to this field more than 20 characters I got
error.
I did a function to control the length of data and put it on trigger but
when it ocurrs I got the error anyway and the trigger not works.
This error is over than trigger execution??

This is the error

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

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*

_________________________________________________________________
Surf and talk on the phone at the same time with broadband Internet access.
Get high-speed for as low as $29.95/month (depending on the local service
providers in your area). https://broadband.msn.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun 2003-10-29 15:53:34 selecting information from two tables (problem)
Previous Message Emmon Simbo 2003-10-29 15:03:46 Re: Viewing linked large postgres tables with Access: Running out of memory