From: "Surabhi Ahuja " <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2005-02-08 07:55:23
Message-ID: CE5C48E227F8ED4990FAC4332100ADC621B4DA@EVS.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

in a transaction i try to insert into a table1, followed by insert into table 2 then insert into table 3 and last insert into table 4. However if a unique key violation occurs in the table 1 , the whole trabnsaction aborts. is there no way , where i can ignore this violation, and continue with the remaining insertions.
?

Responses

  • Re: at 2005-02-08 10:00:57 from Jan Poslusny

Browse pgsql-general by date

  From Date Subject
Next Message javier wilson 2005-02-08 08:19:41 create aggregates to concatenate
Previous Message Tom Lane 2005-02-08 06:45:44 Re: a SELECT FOR UPDATE question