Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id CB0AC9FA1A6
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 28 Dec 2006 10:25:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 16459-10 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Thu, 28 Dec 2006 10:25:26 -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 06ED69FA182
	for <pgsql-interfaces@postgresql.org>;
	Thu, 28 Dec 2006 10:25:32 -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 68DB7D764B;
	Thu, 28 Dec 2006 15:25:30 +0100 (CET)
Received: by feivel (Postfix, from userid 1000)
	id EB4DDD7030; Thu, 28 Dec 2006 15:25:29 +0100 (CET)
Date: Thu, 28 Dec 2006 15:25:29 +0100
From: Michael Meskes <meskes@postgresql.org>
To: Ken Jennings <ken_jennings@bellsouth.net>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: SQLSTATE not updated in ecpg program.
Message-ID: <20061228142529.GA18321@feivel.credativ.de>
Mail-Followup-To: Ken Jennings <ken_jennings@bellsouth.net>,
	pgsql-interfaces@postgresql.org
References: <200612272326.10049.ken_jennings@bellsouth.net>
	<20061228123434.GA29626@feivel.credativ.de>
	<200612280807.09631.ken_jennings@bellsouth.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200612280807.09631.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/37
X-Sequence-Number: 6371

On Thu, Dec 28, 2006 at 08:07:09AM -0500, Ken Jennings wrote:
> This is an alternate version of the program with debugging where I dump the 
> contents of all the useful elements of sqlca.  The file output.txt shows the 
> output of a couple runs (on 8.2.0):
> http://www.kenjennings.cc/st/prg/ux/test_pgc_new_src.tar.gz

And this is run in a all 8.2 environment? I just tested with 8.2 ecpglib
against 8.1 database and got some useful information:

sqlstate[0] =0
sqlstate[1] =8
sqlstate[2] =0
sqlstate[3] =0
sqlstate[4] =1

Using the 8.1 libs I seem to get a memory overrun:

./testpgc test1234 postgres
...
sqlstate[0] =1
sqlstate[1] =2
sqlstate[2] =3
sqlstate[3] =4

Yes, if I use test12 as db name sqlstate[2] and sqlstate[3] are empty.

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!