Обсуждение: Catching DETAIL and HINT

Поиск
Список
Период
Сортировка

Catching DETAIL and HINT

От
"Michael Stanton W."
Дата:

Hello all;

                Does  anybdy know how to catch the DETAIL and HINT sections of the Error Messages?.

                We want to “translate”, for example, Foreign Key Constraint Violation messages into something that a User could understand, using metadata and such like.

 

                We’re using versión 9.1.3

 

Cheers

Mike Stanton W.

Santiago Chile

Re: Catching DETAIL and HINT

От
"David Johnston"
Дата:

What API/Language are you using?

 

Dave

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Stanton W.
Sent: Wednesday, June 27, 2012 1:41 PM
To: pgsql-general@postgresql.org
Cc: desarrollo.mecanica@autocastillo.cl
Subject: [GENERAL] Catching DETAIL and HINT

 

Hello all;

                Does  anybdy know how to catch the DETAIL and HINT sections of the Error Messages?.

                We want to “translate”, for example, Foreign Key Constraint Violation messages into something that a User could understand, using metadata and such like.

 

                We’re using versión 9.1.3

 

Cheers

Mike Stanton W.

Santiago Chile

Re: Catching DETAIL and HINT

От
"Michael Stanton W."
Дата:

We want to create a function using  plpgsql

 

De: David Johnston [mailto:polobo@yahoo.com]
Enviado el: Miércoles, 27 de Junio de 2012 16:54
Para: 'Michael Stanton W.'; pgsql-general@postgresql.org
CC: desarrollo.mecanica@autocastillo.cl
Asunto: RE: [GENERAL] Catching DETAIL and HINT

 

What API/Language are you using?

 

Dave

 

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Stanton W.
Sent: Wednesday, June 27, 2012 1:41 PM
To: pgsql-general@postgresql.org
Cc: desarrollo.mecanica@autocastillo.cl
Subject: [GENERAL] Catching DETAIL and HINT

 

Hello all;

                Does  anybdy know how to catch the DETAIL and HINT sections of the Error Messages?.

                We want to “translate”, for example, Foreign Key Constraint Violation messages into something that a User could understand, using metadata and such like.

 

                We’re using versión 9.1.3

 

Cheers

Mike Stanton W.

Santiago Chile

Re: Catching DETAIL and HINT

От
Tom Lane
Дата:
"Michael Stanton W." <mike.stanton@autocastillo.cl> writes:
> We want to create a function using  plpgsql

9.2 has a feature (GET STACKED DIAGNOSTICS command) for retrieving message
detail and hint fields in a plpgsql exception handler.  There's no way
to get hold of them in existing releases, unfortunately.

            regards, tom lane

A. Because responses come before questions.
Q. Why is top-posting hard to read?