SP in PostgreSQL

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