Forum OpenACS Development: Re: Patched postgres.so shows SQL error messages in TCL error dump

So what does installing the patch DO rather than not do? :)

I assume it jumps back up the call stack which dumps the offending query?

It shows you the full SQL error message and complete post-bind query in the TCL error string which gets dumped to the web page. So you don't have to go to the log to find it.

Before

Request Error

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind 0or1row nsdb0 {

	select first_name || ' ' || last_name as name, email
	from persons, parties
	where person_id = :user_id
	and person_id = ..."
    ("uplevel" body line 1)
    invoked from within
After
Request Error

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Attribute 'first_name' not found

SQL: 

	select first_name || ' ' || last_name as name, email
	from persons, parties
	where person_id = '2604'
	and person_id = party_id

    
    while executing
"ns_pg_bind 0or1row nsdb0 {

	select first_name || ' ' || last_name as name, email
	from persons, parties
	where person_id = :user_id
	and person_id = ..."
    ("uplevel" body line 1)

Also, a mistake in my instructions - postgres.so is in /usr/local/aolserver/bin.