Re: Reg : Error Handling - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: Reg : Error Handling
Date
Msg-id 20051020061825.GA71430@winnie.fuhr.org
Whole thread Raw
In response to Re: Reg : Error Handling  ("sandhya" <sandhyar@amiindia.co.in>)
List pgsql-admin
On Thu, Oct 20, 2005 at 10:30:36AM +0530, sandhya wrote:
> I am able to get the error code as a return value from the function using,
> return (PQresultErrorField(res,PG_DIAG_SQLSTATE));
> Problem is i don't know how to generalize the messages once i get
> this....Pls any one help me in this regard

The "PostgreSQL Error Codes" appendix to the documentation explains
what each SQLSTATE code means:

http://www.postgresql.org/docs/8.0/interactive/errcodes-appendix.html

See also server/utils/errcodes.h.  I haven't found anywhere in the
source code that provides mappings from SQLSTATE to generic messages,
so you'll probably have to do that yourself.

--
Michael Fuhr

pgsql-admin by date:

Previous
From: "sandhya"
Date:
Subject: Re: Reg : Error Handling
Next
From: Peter Eisentraut
Date:
Subject: Re: Possible bug in pgAdmin III v1.2.2