PGSQL and NPGSQL does not display exact error while using with VB.NET. We faced a lot of trouble to find out actually where an error occured.
For example in a routine we need to insert a record to the table. I forgot to use "values" clause in the Insert Query, but PGSQL displayed error "No source code available" in the routine where we opened the connection. Whereas, Oracle displayed exact error that "Invalid Insert statement". There are many such situation where we remained puzzled and later found error somewhere else. -- View this message in context: http://www.nabble.com/PGSQL-and-NPGSQL-does-not-display-exact-errors-tf3286839.html#a9142659 Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
