Re: commit within function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux