Re: transactions on Postgresql

>>>>> "DR" == Dave Robinson <lachesis@ignmail.com> writes:

>> my problem : if an insert fail, all following insert are aborted :-(
>>
>> NB :         it's not necessary to me that ALL  inserts , will be done
>> with succes.
>> my question  is :   if  a  BAD insert fail ,  how can i do  for  doing
>> other inserts who may be are GOOD ?
>>
>> thanks a lot for help ;-)


DR> You want to look at wrapping your do statement into an eval block you
DR> can then capture the insert death in $@

Perl does not die; Postgres goes into ABORT STATE after the first
failure, and that is his problem.  The only real way around this is to
not put the whole thing in a transaction.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/