Re: debugging functions

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: debugging functions
Дата
Msg-id CAFj8pRDoNqGh1jpULqre4A+KNhEiooxV_HizHJKumjiUNwa9DA@mail.gmail.com
обсуждение исходный текст
Ответ на debugging functions  (Seb <spluque@gmail.com>)
Список pgsql-general
Hello

I don't know any tool that can do what you want. You can write your function as fault tolerant - you can trap errors, and you can print a some messages.

That is all what is possible

Regards

Pavel


2014-03-12 20:29 GMT+01:00 Seb <spluque@gmail.com>:
Hi,

I am aware of the edb-debugger that one can use with pgadmin for
debugging functions.  However, I am looking for a solution that doesn't
involve such additions to the server.  I'm using a function in a SELECT
query, but it's failing for some rows in a very large table.  By using
LIMIT and OFFSET I see that it runs fine for some parts of the table.
Is there some way to print the rows where it fails?  For now, I've
simply modified the function to return a value that I can use in the
SELECT query to filtering, but I'm wondering whether there's a parameter
or setting that would accomplish the same thing without modifying the
function.

Thanks,

--
Seb



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Seb
Дата:
Сообщение: debugging functions
Следующее
От: David Welton
Дата:
Сообщение: Re: named queries and the wire protocol