All geek questions in one place

Debugging PL / Python Functions

I just practiced some happy development and wrote a lot of code without testing each step, as usual.

So, now I have several hundred lines of code with an error somewhere ... I use pgAdmin III to write Python and I write it in my Query Tool, which is used for regular SQL queries. I will not go past my Python code, since I do not need help with this particular problem. Instead, I get a tool that will provide me with the exact position in the PL / Python function where the error occurred. To see the reason for this, the following error message I get, and I have a way to debug where the error occurred:

********** Error ********** ERROR: invalid input syntax for integer: "atextstring" SQL state: 22P02
+4
source share
1 answer

I used PL / pgSQL for a while and I did not find a tool for debbuging.

+4
source

Source: https://habr.com/ru/post/1341620/

More articles:


All Articles