Hello All, I am using PostgreSQL 8.2. I am having 2 SP's ,second one is called from the first one. is there any solution to commit the updates done by the second SP only?? when I wrote commit inside second SP it gives me following error ERROR: SPI_execute_plan failed executing query "commit": SPI_ERROR_TRANSACTION Thanks in advance!!! With Regards Ashish Karalkar __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
