Re: transactions on Postgresql

>>>>> "DR" == Dave Robinson <lachesis(at)ignmail(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/