Re: how to emit line number in a function?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: how to emit line number in a function?
Дата
Msg-id 436A42EC.1060609@archonet.com
обсуждение исходный текст
Ответ на how to emit line number in a function?  (Bricklen Anderson <BAnderson@PresiNET.com>)
Ответы Re: how to emit line number in a function?  (Bricklen Anderson <BAnderson@PresiNET.com>)
Список pgsql-general
Bricklen Anderson wrote:
> I couldn't find any useful references in the docs or archives for emitting the
> line number of a plpgsql function (in a RAISE statement). I'd like to use it for
> debugging some complex functions.
> Does anyone have any tips on where to look, or an example of this?

I don't think you can do so yourself. However, recent versions of PG
should display the line number of a RAISE NOTICE or similar if you have
the error verbosity high enough.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: SCassidy@overlandstorage.com
Дата:
Сообщение: Re: Changing ids conflicting with serial values?
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Querying for related tables