Index: openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/Attic/00-database-procs-postgresql.tcl,v diff -u -r1.25 -r1.26 --- openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl 16 Sep 2001 13:34:15 -0000 1.25 +++ openacs-4/packages/acs-tcl/tcl/00-database-procs-postgresql.tcl 20 Nov 2001 02:04:50 -0000 1.26 @@ -40,14 +40,14 @@ # if a table is being created, we need to bypass things, too (OpenACS - Ben). set test_sql [db_qd_replace_sql $full_statement_name $sql] if {[regexp -nocase -- {^\s*select} $test_sql match]} { - db_qd_log Notice "PLPGSQL: bypassed anon function" + db_qd_log Debug "PLPGSQL: bypassed anon function" set selection [db_exec 0or1row $db $full_statement_name $sql] } elseif {[regexp -nocase -- {^\s*create table} $test_sql match] || [regexp -nocase -- {^\s*drop table} $test_sql match]} { - db_qd_log Notice "PLPGSQL: bypassed anon function -- create/drop table" + db_qd_log Debug "PLPGSQL: bypassed anon function -- create/drop table" set selection [db_exec dml $db $full_statement_name $sql] return "" } else { - db_qd_log Notice "PLPGSQL: using anonymous function" + db_qd_log Debug "PLPGSQL: using anonymous function" set selection [db_exec_plpgsql $db $full_statement_name $sql \ $statement_name] } @@ -74,12 +74,12 @@ } { set start_time [clock clicks] - db_qd_log Notice "PRE-QD: the SQL is $pre_sql" + db_qd_log Debug "PRE-QD: the SQL is $pre_sql" # Query Dispatcher (OpenACS - ben) set sql [db_qd_replace_sql $statement_name $pre_sql] - db_qd_log Notice "POST-QD: the SQL is $sql" + db_qd_log Debug "POST-QD: the SQL is $sql" set unique_id [db_nextval "anon_func_seq"] @@ -89,7 +89,7 @@ if {![string equal $sql $pre_sql]} { set sql [uplevel 2 [list subst -nobackslashes $sql]] } - db_qd_log Notice "PLPGSQL: converted: $sql to: select $function_name ()" + db_qd_log Debug "PLPGSQL: converted: $sql to: select $function_name ()" # create a function definition statement for the inline code # binding is emulated in tcl. (OpenACS - Dan) @@ -203,7 +203,7 @@ } { set start_time [clock clicks] - db_qd_log Notice "PRE-QD: the SQL is $pre_sql for $statement_name" + db_qd_log Debug "PRE-QD: the SQL is $pre_sql for $statement_name" # Query Dispatcher (OpenACS - ben) set sql [db_qd_replace_sql $statement_name $pre_sql] @@ -213,7 +213,7 @@ set sql [uplevel $ulevel [list subst -nobackslashes $sql]] } - db_qd_log Notice "POST-QD: the SQL is $sql" + db_qd_log Debug "POST-QD: the SQL is $sql" set errno [catch { upvar bind bind