On Wed, 2007-01-10 at 06:01 -0800, Ashish Karalkar wrote: > 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 SP/Functions are automatically performed in a transaction. Joshua D. Drake > > > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
