Who writes "CONTEXT" ?

Started by Nicola Farinaover 16 years ago3 messagesgeneral
Jump to latest
#1Nicola Farina
nicola.farina@info-line.it

Hello all,

I am trying to debug a plperlu set of stored procedures. in pg 8.3.7.
When I launch a procedure I see messages, in the output window,
beginning with the string "CONTEXT: SQL statement "SELECT ..."
Which procedure or predefined function prints this kind of messages ? Is
this a standard pg message ?
Thanks
Bye
Nicola

--
Nicola Farina

Ufficio Progetti

Info Line Srl, Via Colorno 63/a, 43122 Parma
Tel 0521-609811
Fax 0521-606924
e-mail: nicola.farina@info-line.it
sito web: http://www.info-line.it

*** AVVISO di RISERVATEZZA ***

Ai sensi del D.lgs 196/03 si precisa che il contenuto di questo messaggio � rivolto unicamente alle persone cui � indirizzato e pu� contenere informazioni la cui riservatezza � tutelata legalmente.
Ne sono vietati la riproduzione, la diffusione e l'uso in mancanza di autorizzazione del destinatario. Se l'avete ricevuto per errore vogliate eliminare il messaggio in modo permanente e darcene cortesemente notizia rispondendo all'indirizzo:
segreteria@info-line.it

#2Filip Rembiałkowski
plk.zuber@gmail.com
In reply to: Nicola Farina (#1)
Re: Who writes "CONTEXT" ?

2009/12/21 Nicola Farina <nicola.farina@info-line.it>

Hello all,

I am trying to debug a plperlu set of stored procedures. in pg 8.3.7.
When I launch a procedure I see messages, in the output window, beginning
with the string "CONTEXT: SQL statement "SELECT ..."
Which procedure or predefined function prints this kind of messages ? Is
this a standard pg message ?

Yes, it's a standard message. Kind of "stack trace" for postgres messages.

see http://search.postgresql.org/search?u=/docs/8.4/static/&amp;q=CONTEXT

--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@gmail.com
http://filip.rembialkowski.net/

#3Jasen Betts
jasen@xnet.co.nz
In reply to: Nicola Farina (#1)
Re: Who writes "CONTEXT" ?

On 2009-12-21, Nicola Farina <nicola.farina@info-line.it> wrote:

Hello all,

I am trying to debug a plperlu set of stored procedures. in pg 8.3.7.
When I launch a procedure I see messages, in the output window,
beginning with the string "CONTEXT: SQL statement "SELECT ..."
Which procedure or predefined function prints this kind of messages ? Is
this a standard pg message ?

yes that string is from pg. it's optional and can be turned off. (I forget how)