Re: error handling

Hi,

Sean Davis schrieb:
> Probably the simplest way to do this is to load the data into a temporary
> table without the unique constraint then use SQL to insert a "clean" version
> into the new table.  Alternatively, you could use savepoints.  If an insert
> fails, just rollback to that savepoint.  If it succeeds, commit that
> savepoint.
>
But isn't that more overhead than using the trigger? And while inserting
into the clean table, I would have to test if the value is existing or
not. I don't see the advantage of this compared to the script which was
posted a few weeks ago.

Regards,
Verena