Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id CAC559FB281 for ; Tue, 7 Nov 2006 19:00:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 47618-09 for ; Tue, 7 Nov 2006 19:00:44 -0400 (AST) X-Greylist: delayed 00:27:46.46455 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 39A4C9FB22C for ; Tue, 7 Nov 2006 19:00:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from server.firetrust.net (mailserver.firetrust.com [209.213.221.13]) by svr4.postgresql.org (Postfix) with ESMTP id 1AA5A5AF8E8 for ; Tue, 7 Nov 2006 22:32:59 +0000 (GMT) Received: from localhost.localdomain (203-97-61-135.dsl.clear.net.nz [203.97.61.135]) by server.firetrust.net (8.13.8/8.13.8) with SMTP id kA7MWl4T030944 for ; Wed, 8 Nov 2006 11:32:51 +1300 Date: Wed, 8 Nov 2006 11:32:46 +1300 From: Steve Holdoway To: pgsql-admin@postgresql.org Subject: validating incoming string length... Message-Id: <20061108113246.f910a989.steve@firetrust.org> Organization: Firetrust Ltd X-Mailer: Sylpheed version 2.2.6 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV devel-20060726/2173/Wed Nov 8 11:13:18 2006 on server.firetrust.net X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200611/133 X-Sequence-Number: 23660 I'm trying to write a pl/pgsql trigger to validate incoming data to an existing database. One of the fields is defined as character 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