Re: no error numbers - only error messages? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: no error numbers - only error messages?
Date
Msg-id 200207072334.g67NYQk22034@candle.pha.pa.us
Whole thread Raw
In response to no error numbers - only error messages?  (Sander Roobol <sander@blog.at>)
List pgsql-general
Sander Roobol wrote:
> Hello,
>
> I'm having the following problem:
> I'm talking to PostGreSQL using a variety of bindings (libpq, PHP), all
> non-interactive.
> If something goes wrong with one of my queries, I can ask PostGreSQL
> to give an errormessage.
> Unfortunately, errormessages are hard to parse. MySQL for example, works
> around that problem by providing an error number on request, but as far
> as I know, PostGreSQL doesn't.
>
> Did I overlook something or does PostGreSQL really have no error
> numbers? If not, is there any way I reliably parse the error messages?

No, we don't have error numbers.  7.3 will have more error tags,
adding NOTICE and INFO, and a few others.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



pgsql-general by date:

Previous
From: Christopher Murtagh
Date:
Subject: PostgreSQL vs Postgres
Next
From: "Kym Farnik"
Date:
Subject: Re: I am being interviewed by OReilly