no error context for index updates?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема no error context for index updates?
Дата
Msg-id 1328033845.6603.10.camel@vanquo.pezone.net
обсуждение исходный текст
Ответы Re: no error context for index updates?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Attached is a test case reduced from a real application.  There is a
table with an index on a function written in PL/Python.  There is a
second PL/Python function that executes an INSERT into the table,
causing an index update.  If the function used by the index fails, we
get an error message with context information, e.g.,

ERROR:  spiexceptions.InternalError: plpy.Error: boom
CONTEXT:  Traceback (most recent call last):
  PL/Python function "test2", line 3, in <module>
    rv = plpy.execute(plan, [a, b])
PL/Python function "test2"

I had been debugging the heck out of this function trying to figure out
where that particular exception is coming from, but it wasn't happening
on that function at all.

What I'd like to see if additional context like this:

CONTEXT: index updates of table "test"
CONTEXT: ....
PL/Python function "test1"

The second test case I'm attaching shows that the same thing happens
with PL/Perl, so it's not a problem of a particular PL.

Any ideas whether we could make this happen?


Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: JSON for PG 9.2
Следующее
От: Abhijit Menon-Sen
Дата:
Сообщение: Re: JSON for PG 9.2