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.
Date: Thu, 28 Dec 2006 15:25:29 +0100
Message-ID: <20061228142529.GA18321@feivel.credativ.de> (raw)
In-Reply-To: <200612280807.09631.ken_jennings@bellsouth.net>
References: <200612272326.10049.ken_jennings@bellsouth.net>
<20061228123434.GA29626@feivel.credativ.de>
<200612280807.09631.ken_jennings@bellsouth.net>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, ken_jennings@bellsouth.net
Subject: Re: SQLSTATE not updated in ecpg program.
In-Reply-To: <20061228142529.GA18321@feivel.credativ.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox