Ignoring an SQL INSERT error - Mailing list pgsql-novice

From Shawn Chisholm
Subject Ignoring an SQL INSERT error
Date
Msg-id FE045D4D9F7AED4CBFF1B3B813C8533702C76E87@mail.sandvine.com
Whole thread Raw
Responses Re: Ignoring an SQL INSERT error
List pgsql-novice
Hi,

Does anyone know of a way to perform an insert that does not abort the
transaction if it fails?

I am trying to implement a rule that will allow the insertion data into a
view (for backward compatability) by performing inserts in other tables, and
there are situations where an insert into one of the underlying tables is
unnecessary and causes a unique key constraint violation.  Ideally I would
like to do an insert and ignore any errors...

Thanks,

Shawn

PS. I am using PostgreSql 7.4



pgsql-novice by date:

Previous
From: Derrick Betts
Date:
Subject: Re: Dynamic Array into pl/pgSQL function
Next
From: celoftis@unity.ncsu.edu
Date:
Subject: Shut down postgres server...