Postgres Pro
Downloads
Home   >   mailing lists

validating incoming string length... - Mailing list pgsql-admin

From Steve Holdoway
Subject validating incoming string length...
Date
Msg-id 20061108113246.f910a989.steve@firetrust.org
Whole thread Raw
Responses Re: validating incoming string length...  (Jerry Sievers <jerry@jerrysievers.com>)
List pgsql-admin
Tree view 
I'm trying to write a pl/pgsql trigger to validate incoming data to an existing database. One of the fields is defined
ascharacter varying (255). Is there any way of catching over-length data on inserts and silently dropping them? At the
moment,I'm getting the error 'ERROR:  value too long for type character varying(255)' no matter what I try. 

And yes, I inherited this!

Cheers,

Steve

pgsql-admin by date:

Previous
From: "Michael McCloskey"
Date:
Subject: Postgres at startup
Next
From: "jatrojoomla"
Date:
Subject: how & from where to start & admin pgsql on red hat ES 3