Re: [GENERAL] SP in PostgreSQL

2007-01-10 Thread Joshua D. Drake
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 >

Re: [GENERAL] SP in PostgreSQL

2007-01-10 Thread A. Kretschmer
am Wed, dem 10.01.2007, um 6:01:41 -0800 mailte Ashish Karalkar folgendes: > 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?? No, you can't. A function is a trans

[GENERAL] SP in PostgreSQL

2007-01-10 Thread Ashish Karalkar
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": SP