In article <C00437CF.3F9D0%scott_ribe@xxxxxxxxxxxxxxx>, scott_ribe@xxxxxxxxxxxxxxx says... > > where we can check the execution of our program or we can dry run our code, is > > there aby option or feature with PGSQL for the same purpose that we can check > > our PGSQL statements? > > No, unfortunately not. What I do is: > > - error check everything you can, and use RAISE EXCEPTION with descriptive > error messages > > - come up with test cases to exercise all branches of code > > - print useful debugging info while tracking down problems > > > EMS Postgresql Manager has a debugger in it. Its not perfect but still it is quite useful. B.
