Forum OpenACS Q&A: PG Driver problem when using search

I get this error: handle "select" is not of type "PostgreSQL" while executing "ns_pg_bind select nsdb2 { select arg_name, arg_default from acs_function_args where function = upper(:function_name) order by ..." ("uplevel" body line 1) invoked from within "uplevel $ulevel [list ns_pg_bind $type $db $sql" ("postgresql" arm line 2) invoked from within "switch $driverkey { oracle { return [uplevel $ulevel [list ns_ora $type $db $sql] $args] } ..." invoked from within "db_exec select $db $full_statement_name $sql" invoked from within "set selection [db_exec select $db $full_statement_name $sql]" ("uplevel" body line 2) invoked from within "uplevel 1 $code_block " invoked from within "db_with_handle -dbn $dbn db { set selection [db_exec select $db $full_statement_name $sql] set result [list] while { [db_get..." (procedure "db_list_of_lists" line 9) invoked from within "db_list_of_lists get_function_args {}" (procedure "plpgsql_utility::get_function_args" line 2) invoked from within "plpgsql_utility::get_function_args search_observer__dequeue" ("eval" body line 1) invoked from within "eval $script" invoked from within "ns_cache eval util_memoize $script { list $current_time [eval $script] }" (procedure "util_memoize" line 20) invoked from within "util_memoize [list plpgsql_utility::get_function_args $function_name" (procedure "plpgsql_utility::generate_attribute_parameter_call" line 4) invoked from within "plpgsql_utility::generate_attribute_parameter_call \ -prepend ":" \ ${package_name}__${object_name} \ $pieces" invoked from within "subst -nobackslashes \n\n\tselect\ \$\{package_name\}__\$\{object_name\}(\[plpgsql_utility::generate_attribute_parameter_call\ \\\n\t\t-prepend\ \":\"..." ("uplevel" body line 1) invoked from within "uplevel $ulevel [list subst -nobackslashes $sql" (procedure "db_exec" line 16) invoked from within "db_exec 0or1row $db $full_statement_name $sql" invoked from within "if {[regexp -nocase -- {^\s*select} $test_sql match]} { ns_log Debug "PLPGSQL: bypassed anon function" set selection [..." ("uplevel" body line 6) invoked from within "uplevel 1 $code_block " invoked from within "db_with_handle -dbn $dbn db { # plsql calls that are simple selects bypass the plpgsql # mechanism for creating anonymous fun..." (procedure "db_exec_plsql" line 57) invoked from within "db_exec_plsql exec_func_plsql {}" (procedure "package_exec_plsql" line 31) invoked from within "package_exec_plsql -var_list [list [list object_id $object_id] [list event_date $event_date] [list event $event] ] search_observer dequeue" (procedure "search::dequeue" line 3) invoked from within "search::dequeue -object_id $object_id -event_date $event_date -event $event" ("uplevel" body line 49) invoked from within "uplevel 1 $code_block " ("1" arm line 1) invoked from within "switch $errno { 0 { # TCL_OK } 1 { # TCL_ERROR ..." ("while" body line 20) invoked from within "while { [db_getrow $db $selection] } { incr counter if { [info exists array_val] } { unset array_val ..." ("uplevel" body line 5) invoked from within "uplevel 1 $code_block " invoked from within "db_with_handle -dbn $dbn db { set selection [db_exec select $db $full_statement_name $sql] set counter 0 while { [db_getrow $..." (procedure "db_foreach" line 36) invoked from within "db_foreach search_observer_queue_entry {} { switch -- $event { INSERT { # Don't bother reindexing if we've alread..." (procedure "search::indexer" line 12) invoked from within "search::indexer" ("eval" body line 1) invoked from within "eval [concat [list $proc] $args]" (procedure "ad_run_scheduled_proc" line 42) invoked from within "ad_run_scheduled_proc {t f 30 search::indexer {} 1102697443 0 f}" I was using an Oracle pool along with the PostgreSQL pools earlier but I commented the Oracle pool out in the config file and the error persists. Any ideas?
Collapse
Posted by Peter Marklund on
oh, turns out I still had an oracle pool lying around and that was indeed causing the problem. Please ignore my post...