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?
    
  
  
	Posted by 
	
              
	    Peter Marklund
	   on 12/10/04 06:17 PM
  
  oh, turns out I still had an oracle pool lying around and that was indeed causing the problem. Please ignore my post...
    
  
   
            
            


