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
