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

If you have verbose and logsqlerrors set to true for each of your database pools, then you should see plenty of information in the server log so that you can easily locate the source of your error.  An exception to this might be errors in pl/pgsql code, as the error messages for pl/pgsql code can be kind of opaque.