Forum OpenACS Q&A: Response to What does it take to get Postgresql database error detail in tracebacks?

Robert, that's exactly what I want.  I'm not at the point of debugging PG/plsql functions yet (but I will be).

I was referring to the easier problem of simple db_dml, such as inserting data into the database.  Another instance is the all encompasing "Query did not return rows" kind of answer (well, what did it return?)  Using the hint about turning on sql debugging, I figured out that the system comes that way.  Looking further up the log files than I expected I should have, I found the actual error, along with the bind substitution, which is nice to see.  It would be so much more useful to just get that error, along with the attempted SQL, in the TCL traceback on the web page.

The more I write about it, though, the more I believe this is an aolserver issue, vs. an OpenACS issue.