开发者

Debugging PL/Python functions

开发者 https://www.devze.com 2023-02-14 08:22 出处:网络
I just practiced some happy engineering and wrote lots of code without testing each step as I usually do.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消