Postgres Pro
Downloads
Home   >   mailing lists

Thread: Catching DETAIL and HINT

Catching DETAIL and HINT

From
"Michael Stanton W."
Date:

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

From
"David Johnston"
Date:

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

From
"Michael Stanton W."
Date:

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

From
Tom Lane
Date:
"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?