> 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 -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 665-7007 voice