Thanks, Don, this works, at least I can start up and do 'normal' things (i.e. those that don't use 'extra' pool). Do get the following error tough:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
while executing
"ns_pg_bind select nsdb0 {select
gl_code, gl_desc
from
gltm_glmaster}"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
invoked from within
"db_exec select $db $statement_name $sql 3"
(procedure "template::query::multirow" line 5)
invoked from within
...
From which I deduce that by default it tries to take data from Postgres pool.
The data source for the page is as follows, a very simple one -- just for testing:
# @datasource coa multirow
# Test data source
# @column cnt is the count of records from dual
set dbpool "boflex"
set db [ns_db gethandle $dbpool]
set query "select count(*) cnt from dual"
template::query get_coa coa multirow $query -db $db
