Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id CD47A9FA28E for ; Thu, 28 Dec 2006 08:34:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 27874-01 for ; Thu, 28 Dec 2006 08:34:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id C85469FA2EA for ; Thu, 28 Dec 2006 08:34:37 -0400 (AST) Received: from feivel (p50897538.dip.t-dialin.net [80.137.117.56]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 4D5D1D764B; Thu, 28 Dec 2006 13:34:35 +0100 (CET) Received: by feivel (Postfix, from userid 1000) id AF904D6D82; Thu, 28 Dec 2006 13:34:34 +0100 (CET) Date: Thu, 28 Dec 2006 13:34:34 +0100 From: Michael Meskes To: Ken Jennings Cc: pgsql-interfaces@postgresql.org Subject: Re: SQLSTATE not updated in ecpg program. Message-ID: <20061228123434.GA29626@feivel.credativ.de> Mail-Followup-To: Ken Jennings , pgsql-interfaces@postgresql.org References: <200612272326.10049.ken_jennings@bellsouth.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200612272326.10049.ken_jennings@bellsouth.net> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/35 X-Sequence-Number: 6369 On Wed, Dec 27, 2006 at 11:26:09PM -0500, Ken Jennings wrote: > A simple test program compiled with ecpg worked fine for 8.1.5 > which can be found here: http://www.kenjennings.cc/st/prg/ux/test_pgc.tar.gz > The program does simple error checking using sqlca.sqlstate which the postgres > docs (31.11.2) suggest is preferable to sqlca.sqlcode. Could you please upload a tarball that contains the sources and the makefile and not the RCS archive which this one seems to be? I will have a look at it asap. Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!