Re: debugging functions

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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>