PHPBuilder.com has posted part two of a series they're working through introducing PHP developers to the world of exception handling in the Postgres database.
Last week we left off with an example where notice, exception and log levels are sent to the client. This week we present more POSTGRES exception examples, and continue with our article on Postgres exception handling.
They create a few examples:
- handling other error conditions with OTHERS
- using f_ex2
- returning NO_DATA_FOUND and TOO_MANY_ROWS
- handling exceptions like table constraints
- nested exceptions
- using f_ex5
- a RAISE EXCEPTION dilemma
- using f_ext1