X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 71DC29DCC94 for ; Thu, 12 Jan 2006 05:01:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50379-03 for ; Thu, 12 Jan 2006 05:01:03 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 188119DCCA8 for ; Thu, 12 Jan 2006 05:01:00 -0400 (AST) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr4.postgresql.org (Postfix) with ESMTP id 367CC5AF176 for ; Thu, 12 Jan 2006 09:01:01 +0000 (GMT) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1EwyK8-0000YN-7L for pgsql-sql@postgresql.org; Thu, 12 Jan 2006 10:00:48 +0100 Received: from p548E264F.dip0.t-ipconnect.de ([84.142.38.79]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 12 Jan 2006 10:00:48 +0100 Received: from leo by p548E264F.dip0.t-ipconnect.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 12 Jan 2006 10:00:48 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-sql@postgresql.org From: Rainer Leo Subject: error code =?utf-8?b?aW52YWxpZF9pbnB1dF9zeW50YXg=?= Date: Thu, 12 Jan 2006 08:43:59 +0000 (UTC) Lines: 16 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: main.gmane.org User-Agent: Loom/3.14 (http://gmane.org/) X-Loom-IP: 84.142.38.79 (Mozilla/5.0 (Windows; U; Windows NT 5.0; de; rv:1.8) Gecko/20051111 Firefox/1.5) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[SUBJECT_EXCESS_BASE64=0] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/49 X-Sequence-Number: 23838 I wrote a function which generates SQL statements for INSERTs and UPDATEs, in which I cast the values to the correct datatype. Now I want to catch ERROR: invalid input syntax for integer: "i" but although I tried quite a few I can't find the right error code for this exception. Is it possible that this error can not be caught? Thanks Leo