Henka wrote: > Is it possible to (somehow) commit a specific statement in a trigger > function if the function itself is rolled back because of an error (eg, for a > unique index error)?
No. You can use savepoints (or, in PL/pgSQL functions, EXCEPTION blocks) to inhibit the uniqueness error from aborting the transaction. There is an example in the error catching section of the PL/pgSQL docs about the insert-if-fail-update construct. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
