Postgres Pro
Downloads
Home   >   mailing lists

Re: SP in PostgreSQL - Mailing list pgsql-general

From A. Kretschmer
Subject Re: SP in PostgreSQL
Date
Msg-id 20070110143037.GD6131@a-kretschmer.de
Whole thread Raw
In response to SP in PostgreSQL  (Ashish Karalkar <ashish_karalkar@yahoo.com>)
List pgsql-general
Tree view 
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 transction, you can't do a commit inside.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Ashish Karalkar
Date:
Subject: SP in PostgreSQL
Next
From: James Neff
Date:
Subject: pg_dump and very slow database