SP in PostgreSQL

From: Ashish Karalkar <ashish_karalkar(at)yahoo(dot)com>
To: slony <pgsql-general(at)postgresql(dot)org>
Subject: SP in PostgreSQL
Date: 2007-01-10 14:01:41
Message-ID: 246437.35377.qm@web31609.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Neff 2007-01-10 14:21:59 pg_dump and very slow database
Previous Message Shoaib Mir 2007-01-10 10:52:01 Re: PostgreSQL Connections?