David
David

Reputation: 5016

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 after 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

Upvotes: 5

Views: 1628

Answers (1)

rmcc
rmcc

Reputation: 783

I've been using PL/pgSQL for a while and I haven't found a debbuging tool.

Upvotes: 5

Related Questions