Createlang Pltclu failed
Hi
I was looking for a way to send emails in postgres7.2.3 using the
database. And I found that a procedure pgmail could be used to do this. This
proceudre is in pltclu. I tried to craete this language on my database. But
I got the following error:
Error: Load of file /usr/lib/pgsql/pltcl.so failed: /usr/lib/pgsql/pltcl.so:
Undefined symbol: Tcl_CreateSlave
Createlang: language installation failed
Can anybody help me out with this problem? How do I use pltclu on postgres?
I use postgres7.2.3 on Red Hat linux.
And also can anybody tell me more about the tcl script pgmail?
Thanx
Madhavi
--- Madhavi <madhavi@zoniac.com> wrote:I don't have tcl in my database. And I have done it
as su - postgres and
only then createlang pltclu ion. But Now I'm getting
the error that says,
pltcl_call_handler does not existIs it because I have downloaded pltcl.so file and
tried installing it afetr
I have already installed postgres? Is it a MUSt that
I install tcl along
with postgres? Or is anything else wrong?Thanx
MAdhaviError: Load of file /usr/lib/pgsql/pltcl.so
failed:
/usr/lib/pgsql/pltcl.so:
Undefined symbol: Tcl_CreateSlave
Createlang: language installation failed
u have to define a handler for the the language
these are the supported languages
'plpgsql', 'pltcl', 'pltclu', and 'plperl'.
run this script at postgres
---------------------------
CREATE FUNCTION pltcl_call_handler () RETURNS opaque
AS '/usr/lib/pgsql/pltcl.so'
LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'pltcl'
HANDLER pltcl_call_handler
LANCOMPILER 'PL/tcl';
this should solve the problem
suresh
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Import Notes
Reply to msg id not found: NHBBINJKLKIANIDACONLAEFMCAAA.madhavi@zoniac.com | Resolved by subject fallback
Error: Load of file /usr/lib/pgsql/pltcl.so
failed:
/usr/lib/pgsql/pltcl.so:
Undefined symbol: Tcl_CreateSlave
Createlang: language installation failed
u have to define a handler for the the language
these are the supported languages
'plpgsql', 'pltcl', 'pltclu', and 'plperl'.
run this script at postgres
---------------------------
CREATE FUNCTION pltcl_call_handler () RETURNS opaque
AS '/usr/lib/pgsql/pltcl.so'
LANGUAGE 'C';
CREATE PROCEDURAL LANGUAGE 'pltcl'
HANDLER pltcl_call_handler
LANCOMPILER 'PL/tcl';
this should solve the problem
suresh
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Import Notes
Reply to msg id not found: NHBBINJKLKIANIDACONLAEFMCAAA.madhavi@zoniac.com | Resolved by subject fallback