By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,883 Members | 2,037 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,883 IT Pros & Developers. It's quick & easy.

Exception handling in postgresql

P: 2
HI,

Im new to postgresql i have written two procedures.procedure1 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.
Jun 10 '10 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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/curre...ERROR-TRAPPING
Maybe this list of exceptions will be useful
http://www.postgresql.org/docs/curre...-appendix.html
Jun 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.