I am developing an Information Management System. I am using Pgaccess as front end. The backend is PostgreSQL-6.5.2 and OS is Red Hat Linux 6.1, on Intel P-II 350 MHz connected with LAN. I have installed them using RPM of Linux. I have learned some of the Tcl and Tk for programming.
Functions of pgtcl :
I have loaded pgtcl language using handler /usr/lib/libpgtcl.so which linkes to /usr/lib/libpgtcl.so.0.2. The language and function creation works fine. But when calling the function, it gives following error :
=> CREATE FUNCTION trial () RETURNS int2 AS ' return 33; ' LANGUAGE 'pgtcl' ;
CREATE
=> SELECT trial ();
ERROR : Load of file /usr/lib/libpgtcl.so failed : /usr/lib/libpgtcl.so : undefined symbol : Tcl_GetChannel
=>
Thus I can not use any function defined in Tcl. This was just a simplest function for trial.