CONTEXT messages for raise EXCEPTION - Mailing list pgsql-admin

From Michael Shapiro
Subject CONTEXT messages for raise EXCEPTION
Date
Msg-id ca3a8da20802130927u1abe9c2cgf67dfe83bb159592@mail.gmail.com
Whole thread Raw
Responses Re: CONTEXT messages for raise EXCEPTION  (Michael Fuhr <mike@fuhr.org>)
List pgsql-admin
I am getting a lot of CONTEXT information along with the message when an EXCEPTION is raised. Does anyone know what controls whether EXCEPTIONS add the CONTEXT or not? This problem appeared recently in our server - 8.1.9/linux - but none as far as we can tell we have not changed the configuration. Obviously something did change, but we don't know where to look. Any help would be appreciated.

Here is a sample error message with the CONTEXT

DBD::Pg::db do failed: ERROR:  INSERT BEFORE jobs
 CONTEXT:  SQL statement "insert into jobs (account_id, resource_id, system_account_id, local_jobid, local_charge, submit_time, start_time, end_time, wallduration, jobname, nodecount, processors, queue, grid_job_id) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 ,  $7 ,  $8 ,  $9 ,  $10 ,  $11 ,  $12 ,  $13 ,  $14 )"

NOTE:  We are using Perl's DBI (which may or not be the cause).

pgsql-admin by date:

Previous
From: "Markus Bertheau"
Date:
Subject: Re: 8.3.0 upgrade, confused by documentation
Next
From: "Tena Sakai"
Date:
Subject: Re: 8.3.0 upgrade, confused by documentation