Postgres Pro
Downloads
Home   >   mailing lists

Thread: Createlang Pltclu failed

Createlang Pltclu failed

From
"Madhavi"
Date:
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

Re: Createlang Pltclu failed

From
suresh s
Date:
--- 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 exist
>
> Is 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
> MAdhavi
>
> > 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

Re: Createlang Pltclu failed

From
suresh s
Date:
> 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