Re: no error numbers - only error messages?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Sander Roobol <sander(at)blog(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: no error numbers - only error messages?
Date: 2002-07-07 23:34:26
Message-ID: 200207072334.g67NYQk22034@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kym Farnik 2002-07-07 23:36:15 Re: I am being interviewed by OReilly
Previous Message Christopher Murtagh 2002-07-07 22:36:20 PostgreSQL vs Postgres