On Thu, Jul 16, 2009 at 11:30 AM, Anj Adu<fotographs@xxxxxxxxx> wrote: > I need an explicit commit...i.e i need func B's results to be > available to other transactions when I enter func C > > So...what you are saying is..in Func c > > BEGIN > simulate error > EXCEPTION > WHEN condition [ OR condition ... ] THEN > do nothing; > END; > > Will this cause the transaction to be committed upto the savepoint in > the beginning of function C ? The transaction will be committed or not as a whole. That's how transactions work. If you need part of the data so far processed committed then you need to commit the transaction and start a new one. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
