Debugging PL/Python functions
I just practiced some happy engineering and wrote lots of code without testing each step as I usually do.
So now I have a few hundred lines of code with an error somewhere... I am using pgAdmin III to write the Python and I write it in their Query Tool, which is used for normal SQL queries. I will not past my Python code as I do not want help with this specific problem. Instead I am aft开发者_开发百科er a tool, which will provide me with the exact position in a PL/Python function where the error occurred. To see my reason for wanting this, the following is the error message I am getting, and I have way of debugging where the error occured:
********** Error **********
ERROR: invalid input syntax for integer: "atextstring"
SQL state: 22P02
I've been using PL/pgSQL for a while and I haven't found a debbuging tool.
精彩评论