Hi-
I am getting a msg. stating fatal error: pgsql8 not a valid connnection . I have 9.1 on my system. The last db I used worked fine. I am wondering if I set up the db wrong. If I do a select from psql it works fine.
please assist!
thanks
Code:
proc ::connectToDB {} {
global db
lappend auto_path .
set auto_path [linsert $auto_path 0 /usr/lib/libpgtcl1.5]
# set auto_path [linsert $auto_path 0 /usr/lib/libpgtcl1.5]
package require Pgtcl
set db [pg_connect -conninfo[list host = localhost user = postgres dbname = taskdb]]
set rs [pg_exec $db "select id from task"]
set status [pg_result $rs -status]
tk_messageBox -message "status :$status"
pg_disconnect $db
}