| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com> |
| Cc: | slony <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SP in PostgreSQL |
| Date: | 2007-01-10 15:58:28 |
| Message-ID: | 1168444708.17189.3.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashish Karalkar | 2007-01-10 16:23:28 | Foreign Key Identification |
| Previous Message | Andy Dale | 2007-01-10 15:51:57 | Recording insert, updates, and deletes |