>> In this case, you would want the database to abort on a syntax error, right? >>
Am I completely off thread to ask why HOW we allow an abort on syntax errors? (at least in regard to stored functions)
Shouldn't PostgreSQL do somethng intellignet like *notice* the syntax error in the stored function when it is saved and once again so somethng intellignet?
I don't know what PostgreSQL should do.
I know Oracle would mark the stored function as invalid and mark any stored function invalid if it called an invalid function. Its a fascinating cascade to watch in your IDE.
Rick
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html