Re: Trigger function aborts the transaction on exception

On Sat, Feb 28, 2004 at 03:21:25PM +0530, Rajat Katyal wrote:
> insert into target_table select * from source_table;
>
> Now there could be scenario that in some record error occured due to
> the typecast of char ---> numeric (e.g if it try to insert
> alphanumeric characters in the numeric datatype ) therefore i want to
> catch the execption and want to make it entry in some other table but
> my process of insertion for the other records should go on as they
> have valid records. But it throws the exception and aborts the
> transaction.

Add a where condition to only add lines that are numbers. For example:

insert into target_table select * from source_table where field ~ '^[0-9.]+$';

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
> http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow