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



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Shawn,

Unfortunately, there is no way to do this at this time. It will become
possible when the Nested Transactions feature is added, hopefully in
PostgreSQL7.5 (it is being tested now, you are welcome to help test).

The best way for you to do this on your current production system is to test
for the failure condition in advance.

If you need further help with this, I suggest hopping to the PGSQL-SQL mailing
list; that is where the largest # of people who do rules, triggers, etc. hang
out.

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match