Error size varchar - Mailing list pgsql-general

From Edwin Quijada
Subject Error size varchar
Date
Msg-id BAY1-F38sBv22OJIZ3d00041c0e@hotmail.com
Whole thread Raw
Responses Re: Error size varchar  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: Jeff Kowalczyk
Date:
Subject: Help on update that subselects other records in table, uses joins
Next
From: Stuart Johnston
Date:
Subject: N Texas PostgreSQL Consultant Needed