Daniele Orlandi wrote:
> Hi,
>
> I'm having serious problems with postgresql and TCL as a procedural language.
>
> I did a clean compilantion and install --with-tcl.
> I did an initdb, created the language and a demo function found on the site.
>
> This is the result:
>
> a=> create function pltcl_call_handler() returns opaque
> a-> as '/usr/postgres/lib/pltcl.so'
> a-> language 'C';
> CREATE
> a=>
> a=> create trusted procedural language 'pltcl'
> a-> handler pltcl_call_handler
> a-> lancompiler 'PL/Tcl';
> CREATE
> a=> CREATE FUNCTION tcl_max (int4, int4) RETURNS int4 AS '
> a'> if {$1 > $2} {return $1}
> a'> return $2
> a'> ' LANGUAGE 'pltcl';
> CREATE
Anything correct so far.
> a=> select tcl_max(3,7);
> ERROR: Load of file /usr/postgres/lib/pltcl.so failed: /usr/lib/libtcl8.0.so:
> undefined symbol: stat
There's something wrong with your Tcl installation. The Tcl
shared lib does not correctly reference the library where
stat() is in. It was linked with a missing -l...
You might try to link pltcl.so with the additional library.
Try adding -lm -lc.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck@debis.com (Jan Wieck) #