Re: Getting error codes for failed queries?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Alejandro Forero Cuervo <bachue(at)bachue(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org, boti(at)nimonic(dot)com
Subject: Re: Getting error codes for failed queries?
Date: 2003-10-15 19:02:06
Message-ID: 20031015190206.GD1016@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 15, 2003 at 01:53:49PM -0500, Alejandro Forero Cuervo wrote:
> > In 7.4 there will be error codes.
>
> Does that imply that the socket-level protocol for backend /
> frontend communication will change in version 7.4?

Yes.

> > > Do those strings get translated to different languages, for
> > > instance?
> >
> > Yes.
>
> I guess that rules out the option of parsing them to detect what
> went wrong.

Yes, unless you leave to lc_messages option defined to "C".
Unfortunately this cannot be changed at runtime by non-superusers, I
don't know why.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Porque Kim no hacia nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-10-15 19:04:30 Re: Porting Code to Postgresql
Previous Message Tino Wildenhain 2003-10-15 18:59:09 Re: constant time count(*) ?