Thread: PL/TCL functions won't run

Hi all,
    In working through some problems with rows and variables, I
installed PL/TCL into my Postgres 8.0 installation on Windows XP.
Unfortunately, when I try to run any PL/TCL functions, I get the response:

ERROR:  could not create "normal" interpreter

I have ActiveTCL 8.4.9 installed, and createlang succeeded.  Does anyone
have any idea what needs to be done to get PL/TCL to run on my installation?

Thanks,

Eric

Hi all,
    I managed to resolve this problem, and wanted to post a note on how
I did it:
following Patrick Sampson's work on TCL (thanks, Patrick):
http://archives.postgresql.org/pgsql-cygwin/2004-01/msg00024.php
I added the System Environment variable TCL_LIBRARY
with value: $TCL_DIR\lib\tcl.8.4 ,  in my case (C:\Tcl\lib\tcl8.4)

After rebooting (not sure if just restarting postgres will work), TCL
functions run.
The key is for postgres to be able to find the file init.tcl.

Hope this is useful.

Cheers,

Eric


Eric E wrote:

> Hi all,
>    In working through some problems with rows and variables, I
> installed PL/TCL into my Postgres 8.0 installation on Windows XP.
> Unfortunately, when I try to run any PL/TCL functions, I get the
> response:
>   ERROR:  could not create "normal" interpreter
>
> I have ActiveTCL 8.4.9 installed, and createlang succeeded.  Does
> anyone have any idea what needs to be done to get PL/TCL to run on my
> installation?
>
> Thanks,
>
> Eric
>