>>
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

Reply via email to