Postgres Pro
Downloads
Home   >   mailing lists

SP in PostgreSQL - Mailing list pgsql-general

From Ashish Karalkar
Subject SP in PostgreSQL
Date
Msg-id 246437.35377.qm@web31609.mail.mud.yahoo.com
Whole thread Raw
Responses Re: SP in PostgreSQL  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: SP in PostgreSQL  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: PostgreSQL Connections?
Next
From: "A. Kretschmer"
Date:
Subject: Re: SP in PostgreSQL