Date: Thu, 2 Dec 2004 18:41:15 -0700
From: Michael Fuhr <mike@fuhr.org>
To: X X <junkmbox@yahoo.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: libpq: how to get error code (not message)
Message-ID: <20041203014115.GA5451@winnie.fuhr.org>
References: <20041202060648.GA60984@winnie.fuhr.org>
	<20041202235946.94486.qmail@web51107.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20041202235946.94486.qmail@web51107.mail.yahoo.com>

On Thu, Dec 02, 2004 at 03:59:46PM -0800, X X wrote:

> > I think you're looking for PQresultErrorField()
> > called with the
> > fieldcode argument set to PG_DIAG_SQLSTATE.
>
> Thanks for your reply. This is exactly what I was
> looking for, but the libpq documentation does not
> mention it (at least I did not find).

Appendix A says:

    All messages emitted by the PostgreSQL server are assigned
    five-character error codes that follow the SQL standard's
    conventions for "SQLSTATE" codes. 

The PQresultErrorField() function is documented in the libpq
"Command Execution Functions" section:

http://www.postgresql.org/docs/7.4/static/libpq-exec.html#AEN20619

The documentation says:

    The following field codes are available:
    ...

    PG_DIAG_SQLSTATE
        The SQLSTATE code for the error (see Appendix A). Not localizable.
	Always present.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/