Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 2C6192E004A for ; Tue, 20 May 2008 12:38:48 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62309-01 for ; Tue, 20 May 2008 12:38:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by developer.postgresql.org (Postfix) with ESMTP id 104D82E003B for ; Tue, 20 May 2008 12:38:37 -0300 (ADT) Received: from commandprompt.com (227-54-222-209.mycybernet.net [209.222.54.227]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m4KFdgJB003662 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 20 May 2008 08:39:45 -0700 Date: Tue, 20 May 2008 11:38:32 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: character varying exceeded Message-ID: <20080520153831.GE56707@commandprompt.com> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <81FEAB8CDDC62B42B6E8AA258228BC8805657B98@EVS2.univ.dir.wwu.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <81FEAB8CDDC62B42B6E8AA258228BC8805657B98@EVS2.univ.dir.wwu.edu> User-Agent: Mutt/1.5.17 (2007-11-01) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 20 May 2008 08:39:45 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/171 X-Sequence-Number: 29255 On Tue, May 20, 2008 at 08:19:56AM -0700, Marc Fromm wrote: > breached the 1000 limit. When the user submitted the form the data was > not entered into the database and no error or message was displayed. I think your application is broken. There was so an error message generated. It sounds like your application didn't catch it or display it. If you're using straight psql, then the problem is that client_min_messages is set too high, and clients aren't seeing errors. That's surely a mistake. A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/