How do you debug functions with postgres?

Question

I'm using pgAdmin III 1.8.4 and finding it a harsh mistress.

When writing stored procedures (functions), there's no query compilation. So I have no idea if my function will work until I call it.

How do other people work around this deficiency? (Other than getting it right first time :p)

You might try changing the title to be more clear that you're trying to debug stored procedures — Akrikos
– Akrikos, Commented Feb 20, 2009 at 19:56

Quassnoi · Accepted Answer · 2009-02-20 14:42:48Z

3

EnterpriceDB includes PL/PGSQL Debugger which you can use to step through the code.

answered Feb 20, 2009 at 14:42

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tristan Warner-Smith Over a year ago

Thanks, will have a look. I was thinking more process than a software solution.

torial Over a year ago

Any way to see the values of temp tables while debugging?

Akrikos · Accepted Answer · 2009-02-20 14:45:10Z

2

Write a unit test for it. Granted this won't give you debugging capability, but you should ideally have a unit test suite (and an integration test suite) that you run against your code that proves that it works... and that lets you know when something breaks.

answered Feb 20, 2009 at 14:45

Akrikos

3,6632 gold badges27 silver badges22 bronze badges

2 Comments

Tristan Warner-Smith Over a year ago

Fair point, but waiting until the data access code is up and running before knowing if the pgsql is even valid is more the issue here.

Akrikos Over a year ago

My thinking was along the lines of Test Driven Development & how loosely typed language writers deal with making sure stuff works. Since most errors won't show up until run-time, they write a test suite to exercise their code.

Collectives™ on Stack Overflow

How do you debug functions with postgres?

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related