Exception handling in postgresql

[vardhangiri]

HI,

Im new to postgresql i have written two procedures.proc edure1 takes input from the user array of table objects and loops over them and for each row it calls the second procedure2 where the acutal filling of tables happen.

My problem here is if the user passes 10 record and if record 5 fails then all the other records should be posted to the table.

[rski]

What does it means "5 record fails" what kind of fail would it be?
Did you try to catch exception

http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Maybe this list of exceptions will be useful

http://www.postgresql.org/docs/current/static/errcodes-appendix.html