Forum .LRN Q&A: Response to question on dotLrn status on port to postgres

I just did a fresh openacs+dotlrn install. When I restarted after mounting dotLRN I didn't get the (+) next to it in the site-map. The error log contains:

[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: dbinit: sql(localhost::janine): 'create function __exec_1_rename_folder () returns varchar as '
                 
            begin
                select content_folder__rename(
                    ''5623'',
                    null,
                    ''User''''s Folders'',
                    null
                );
            end;
        
                      ' language 'plpgsql''
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: Querying 'select __exec_1_rename_folder ();'
NOTICE:  Error occurred while executing PL/pgSQL function __exec_1_rename_folder
NOTICE:  line 3 at SQL statement
[22/Jul/2002:10:42:32][4001.1024][-main-] Error: Ns_PgExec: result status: 7 message: ERROR:  SELECT query has no destination for result data.
        If you want to discard the results, use PERFORM instead.

[22/Jul/2002:10:42:32][4001.1024][-main-] Error: dbinit: error(localhost::janine,ERROR:  SELECT query has no destination for result data.
        If you want to discard the results, use PERFORM instead.
): 'select __exec_1_rename_folder ()'
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: Querying 'drop function __exec_1_rename_folder ();'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: dbinit: sql(localhost::janine): 'drop function __exec_1_rename_folder ()'
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: Querying 'abort transaction;'
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: Ns_PgExec: Rolling back transaction
[22/Jul/2002:10:42:32][4001.1024][-main-] Notice: dbinit: sql(localhost::janine): 'abort transaction'
[22/Jul/2002:10:42:32][4001.1024][-main-] Error: Error sourcing /export/staging/janine/packages/dotlrn/tcl/dotlrn-init.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_db 0or1row $db "select $function_name ()""
    invoked from within
"db_exec_plpgsql $db $full_statement_name $sql  $statement_name"
    invoked from within
"if {[regexp -nocase -- {^s*select} $test_sql match]} {
            db_qd_log Debug "PLPGSQL: bypassed anon function"
            set selection [db_ex..."
    ("uplevel" body line 6)

etc, etc.

I don't have time to fix it right now, but wanted to let you guys know about it.