From dpandey@secf.com Wed Apr  6 14:11:37 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 42F8C539E6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 15:11:37 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 66046-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 14:11:33 +0000 (GMT)
Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id 68F17539E2
	for <pgsql-sql@postgresql.org>; Wed,  6 Apr 2005 15:11:32 +0100 (BST)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000585749.msg
	for <pgsql-sql@postgresql.org>; Wed, 06 Apr 2005 07:11:42 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: createlang 'pltclu' with postgreSQL.
Date: Wed, 6 Apr 2005 19:39:02 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0079_01C53AE0.4B701890"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcU6si+Osz1MixeTQTWdNANt6DeNrw==
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Wed, 06 Apr 2005 07:11:42 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Wed, 06 Apr 2005 07:11:46 -0700
Message-Id: <20050406141132.68F17539E2@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.512 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE, MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200504/55
X-Sequence-Number: 20948

This is a multi-part message in MIME format.


------=_NextPart_000_0079_01C53AE0.4B701890
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

I have already installed Postgres 8.0.1.
I am able to use pl/pgsql language but...I want to use language 'pltclu'
with postgreSQL. Its unable to find "pltcl".

I am getting this error.

$ createlang pltclu testdb
ERROR:  could not access file "$libdir/pltcl": No such file or directory
createlang: language installation failed: ERROR:  could not access file
"$libdir/pltcl": No such file or directory

Where this file "$libdir/pltcl" can be found????

I have installed "tk-8.4.9-sol9-sparc-local.gz" and
"tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command.
Any othe configuration required????

Regards
Dinesh Pandey 


------=_NextPart_000_0079_01C53AE0.4B701890
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>createlang 'pltclu' with postgreSQL.</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Verdana">Hi,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">I have already installed Postgres =
8.0.1.</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Verdana">I am able to use pl/pgsql language =
but...I want to use language '<B>pltclu</B>' with postgreSQL. Its unable =
to find &quot;pltcl&quot;.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">I am getting this error.</FONT>
</P>

<P><B><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Verdana">$ createlang =
pltclu testdb</FONT></B>

<BR><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Verdana">ERROR:&nbsp; could =
not access file &quot;$libdir/pltcl&quot;: No such file or =
directory</FONT>

<BR><FONT COLOR=3D"#FF0000" SIZE=3D2 FACE=3D"Verdana">createlang: =
language installation failed: ERROR:&nbsp; could not access file =
&quot;$libdir/pltcl&quot;: No such file or directory</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">Where this file =
&quot;$libdir/pltcl&quot; can be found????</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">I have installed =
&quot;tk-8.4.9-sol9-sparc-local.gz&quot; and =
&quot;tcl-8.4.9-sol9-sparc-local.gz&quot; file using pkgadd -d =
command.</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Verdana">Any othe configuration =
required????</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Verdana">Regards<BR>
Dinesh Pandey</FONT><FONT FACE=3D"Times New Roman"><BR>
</FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_0079_01C53AE0.4B701890--




From mike@fuhr.org Wed Apr  6 15:43:54 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 76AE753497
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 16:43:54 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99211-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 15:43:46 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id 47C4A534AD
	for <pgsql-sql@postgresql.org>; Wed,  6 Apr 2005 16:43:45 +0100 (BST)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j36FhfJW012571
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Wed, 6 Apr 2005 09:43:44 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j36FhfTJ007015;
	Wed, 6 Apr 2005 09:43:41 -0600 (MDT)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j36FheSr007014;
	Wed, 6 Apr 2005 09:43:41 -0600 (MDT) (envelope-from mfuhr)
Date: Wed, 6 Apr 2005 09:43:40 -0600
From: Michael Fuhr <mike@fuhr.org>
To: Dinesh Pandey <dpandey@secf.com>
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: createlang 'pltclu' with postgreSQL.
Message-ID: <20050406154340.GA96591@winnie.fuhr.org>
References: <20050406141132.68F17539E2@svr1.postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20050406141132.68F17539E2@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/57
X-Sequence-Number: 20950

On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote:
> 
> I have already installed Postgres 8.0.1.

How did you install PostgreSQL?  Did you build it from source?

> $ createlang pltclu testdb
> ERROR:  could not access file "$libdir/pltcl": No such file or directory
> createlang: language installation failed: ERROR:  could not access file
> "$libdir/pltcl": No such file or directory

If you built from source, did you run configure with --with-tcl?

> I have installed "tk-8.4.9-sol9-sparc-local.gz" and
> "tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command.
> Any othe configuration required????

When I build PostgreSQL on Solaris 9, I run configure with the
following options (amongst others not shown):

configure --with-tcl --with-tclconfig=/usr/local/lib

Try rebuilding and reinstalling PostgreSQL with those options and
see if you can then createlang pltclu.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



From dpandey@secf.com Wed Apr  6 15:51:30 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4443752A45
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 16:51:30 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 99596-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 15:51:23 +0000 (GMT)
Received: from secf.com (209-128-104-244.BAYAREA.NET [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id 5F80B5295C
	for <pgsql-sql@postgresql.org>; Wed,  6 Apr 2005 16:51:22 +0100 (BST)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000586061.msg
	for <pgsql-sql@postgresql.org>; Wed, 06 Apr 2005 08:51:30 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Michael Fuhr'" <mike@fuhr.org>
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: createlang 'pltclu' with postgreSQL.
Date: Wed, 6 Apr 2005 21:18:47 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00A2_01C53AEE.3AE809C0"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcU6v3vL2BFoag0MS8eTNTPOlRTp5wAAAQtA
In-Reply-To: <20050406154340.GA96591@winnie.fuhr.org>
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Wed, 06 Apr 2005 08:51:30 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Wed, 06 Apr 2005 08:51:34 -0700
Message-Id: <20050406155122.5F80B5295C@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.506 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_30_40, HTML_MESSAGE, HTML_TITLE_EMPTY,
	MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200504/58
X-Sequence-Number: 20951

This is a multi-part message in MIME format.


------=_NextPart_000_00A2_01C53AEE.3AE809C0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi Mike,

Have you installed tcl and tk before popstgres installation and set some
PATH for that before installing postgres.

Because I installed  "tk-8.4.9-sol9-sparc-local.gz" and
"tcl-8.4.9-sol9-sparc-local.gz" after postgres installation.

Can I use "configure --with-tcl --with-tclconfig=/usr/local/lib" this
command now??

What is "/usr/local/lib" - Path of TCL or Path of Postgres installation??

Thanks
Dinesh Pandey

 
 



-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: Wednesday, April 06, 2005 9:14 PM
To: Dinesh Pandey
Cc: 'PostgreSQL'
Subject: Re: [SQL] createlang 'pltclu' with postgreSQL.

On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote:
>
> I have already installed Postgres 8.0.1.

How did you install PostgreSQL?  Did you build it from source?

> $ createlang pltclu testdb
> ERROR:  could not access file "$libdir/pltcl": No such file or
> directory
> createlang: language installation failed: ERROR:  could not access
> file
> "$libdir/pltcl": No such file or directory

If you built from source, did you run configure with --with-tcl?

> I have installed "tk-8.4.9-sol9-sparc-local.gz" and
> "tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command.
> Any othe configuration required????

When I build PostgreSQL on Solaris 9, I run configure with the following
options (amongst others not shown):

configure --with-tcl --with-tclconfig=/usr/local/lib

Try rebuilding and reinstalling PostgreSQL with those options and see if you
can then createlang pltclu.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/



------=_NextPart_000_00A2_01C53AEE.3AE809C0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1491" name=3DGENERATOR></HEAD>
<BODY><!-- Converted from text/plain format -->
<P><FONT size=3D2><FONT face=3DVerdana>Hi Mike,</FONT></FONT></P>
<P><FONT size=3D2><FONT face=3DVerdana>Have you installed <FONT =
color=3D#ff0000>tcl=20
and tk</FONT> before popstgres installation and set some PATH for that =
before=20
installing postgres.<BR><BR>Because I installed&nbsp;=20
"tk-8.4.9-sol9-sparc-local.gz" and "tcl-8.4.9-sol9-sparc-local.gz" after =

postgres installation.<BR><BR>Can I use <STRONG>"configure --with-tcl=20
--with-tclconfig=3D/usr/local/lib"</STRONG> this command =
now??</FONT></FONT></P>
<P><FONT size=3D2><FONT face=3DVerdana>What is =
"<STRONG>/usr/local/lib"</STRONG> -=20
Path of TCL or Path of Postgres installation??<BR><BR>Thanks<BR>Dinesh=20
Pandey</FONT></FONT></P>
<DIV><FONT size=3D2><FONT face=3DVerdana></FONT></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2><FONT face=3DVerdana>&nbsp;</DIV>
<P><BR></FONT><BR>-----Original Message-----<BR>From: Michael Fuhr [<A=20
href=3D"mailto:mike@fuhr.org">mailto:mike@fuhr.org</A>]<BR>Sent: =
Wednesday, April=20
06, 2005 9:14 PM<BR>To: Dinesh Pandey<BR>Cc: 'PostgreSQL'<BR>Subject: =
Re: [SQL]=20
createlang 'pltclu' with postgreSQL.<BR><BR>On Wed, Apr 06, 2005 at =
07:39:02PM=20
+0530, Dinesh Pandey wrote:<BR>&gt;<BR>&gt; I have already installed =
Postgres=20
8.0.1.<BR><BR>How did you install PostgreSQL?&nbsp; Did you build it =
from=20
source?<BR><BR>&gt; $ createlang pltclu testdb<BR>&gt; ERROR:&nbsp; =
could not=20
access file "$libdir/pltcl": No such file or<BR>&gt; directory<BR>&gt;=20
createlang: language installation failed: ERROR:&nbsp; could not =
access<BR>&gt;=20
file<BR>&gt; "$libdir/pltcl": No such file or directory<BR><BR>If you =
built from=20
source, did you run configure with --with-tcl?<BR><BR>&gt; I have =
installed=20
"tk-8.4.9-sol9-sparc-local.gz" and<BR>&gt; =
"tcl-8.4.9-sol9-sparc-local.gz" file=20
using pkgadd -d command.<BR>&gt; Any othe configuration =
required????<BR><BR>When=20
I build PostgreSQL on Solaris 9, I run configure with the following =
options=20
(amongst others not shown):<BR><BR>configure --with-tcl=20
--with-tclconfig=3D/usr/local/lib<BR><BR>Try rebuilding and reinstalling =

PostgreSQL with those options and see if you can then createlang=20
pltclu.<BR><BR>--<BR>Michael Fuhr<BR><A=20
href=3D"http://www.fuhr.org/~mfuhr/">http://www.fuhr.org/~mfuhr/</A><BR><=
/P></FONT></BODY></HTML>

------=_NextPart_000_00A2_01C53AEE.3AE809C0--




From dpandey@secf.com Wed Apr  6 16:02:18 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 77529534D3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 17:02:18 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 05381-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 16:02:16 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id EA852534F1
	for <pgsql-sql@postgresql.org>; Wed,  6 Apr 2005 17:02:12 +0100 (BST)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000586084.msg
	for <pgsql-sql@postgresql.org>; Wed, 06 Apr 2005 09:02:19 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Michael Fuhr'" <mike@fuhr.org>
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: createlang 'pltclu' with postgreSQL.
Date: Wed, 6 Apr 2005 21:29:36 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcU6wTYPLEgX7Ws2TC6zgnCICIM8IQAABTDg
In-Reply-To: <20050406154340.GA96591@winnie.fuhr.org>
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Wed, 06 Apr 2005 09:02:19 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Wed, 06 Apr 2005 09:02:20 -0700
Message-Id: <20050406160212.EA852534F1@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.448 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200504/59
X-Sequence-Number: 20952

1. I installed with compiled package using "pkgadd -d
postgresql-8.0.1-sol9-sparc-local"

2. I haven't used --with-tcl?


Thanks
Dinesh Pandey

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Michael Fuhr
Sent: Wednesday, April 06, 2005 9:14 PM
To: Dinesh Pandey
Cc: 'PostgreSQL'
Subject: Re: [SQL] createlang 'pltclu' with postgreSQL.

On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote:
> 
> I have already installed Postgres 8.0.1.

How did you install PostgreSQL?  Did you build it from source?

> $ createlang pltclu testdb
> ERROR:  could not access file "$libdir/pltcl": No such file or 
> directory
> createlang: language installation failed: ERROR:  could not access 
> file
> "$libdir/pltcl": No such file or directory

If you built from source, did you run configure with --with-tcl?

> I have installed "tk-8.4.9-sol9-sparc-local.gz" and 
> "tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command.
> Any othe configuration required????

When I build PostgreSQL on Solaris 9, I run configure with the following
options (amongst others not shown):

configure --with-tcl --with-tclconfig=/usr/local/lib

Try rebuilding and reinstalling PostgreSQL with those options and see if you
can then createlang pltclu.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org





From dpandey@secf.com Wed Apr  6 16:26:23 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id CF03C5352D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 17:26:23 +0100 (BST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 13524-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  6 Apr 2005 16:26:06 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id 4049353500
	for <pgsql-sql@postgresql.org>; Wed,  6 Apr 2005 17:26:05 +0100 (BST)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000586144.msg
	for <pgsql-sql@postgresql.org>; Wed, 06 Apr 2005 09:25:39 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: FW: createlang 'pltclu' with postgreSQL.
Date: Wed, 6 Apr 2005 21:52:58 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcU6wTYPLEgX7Ws2TC6zgnCICIM8IQAABTDgAAC7wcA=
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Wed, 06 Apr 2005 09:25:39 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Wed, 06 Apr 2005 09:25:43 -0700
Message-Id: <20050406162605.4049353500@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.438 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, MSGID_FROM_MTA_ID
X-Spam-Level: *
X-Archive-Number: 200504/60
X-Sequence-Number: 20953

Unable to run "createlang pltcl testdb"
 
[1]. I tried with this command
	./configure --with-tcl --with-tclconfig=/usr/local/lib

.....
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking whether to build with Tcl... yes
.....
.....
checking for tclsh... /usr/local/bin/tclsh
checking for tclConfig.sh... /usr/local/lib/tclConfig.sh
checking tcl.h usability... yes
checking tcl.h presence... yes
checking for tcl.h... yes


[2]. And then 
	createlang pltcl testdb

ERROR:  could not access file "$libdir/pltcl": No such file or directory
createlang: language installation failed: ERROR:  could not access file
"$libdir/pltcl": No such file or directory

Thanks
Dinesh Pandey

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Dinesh Pandey
Sent: Wednesday, April 06, 2005 9:30 PM
To: 'Michael Fuhr'
Cc: 'PostgreSQL'
Subject: Re: [SQL] createlang 'pltclu' with postgreSQL.

1. I installed with compiled package using "pkgadd -d
postgresql-8.0.1-sol9-sparc-local"

2. I haven't used --with-tcl?


Thanks
Dinesh Pandey

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Michael Fuhr
Sent: Wednesday, April 06, 2005 9:14 PM
To: Dinesh Pandey
Cc: 'PostgreSQL'
Subject: Re: [SQL] createlang 'pltclu' with postgreSQL.

On Wed, Apr 06, 2005 at 07:39:02PM +0530, Dinesh Pandey wrote:
> 
> I have already installed Postgres 8.0.1.

How did you install PostgreSQL?  Did you build it from source?

> $ createlang pltclu testdb
> ERROR:  could not access file "$libdir/pltcl": No such file or 
> directory
> createlang: language installation failed: ERROR:  could not access 
> file
> "$libdir/pltcl": No such file or directory

If you built from source, did you run configure with --with-tcl?

> I have installed "tk-8.4.9-sol9-sparc-local.gz" and 
> "tcl-8.4.9-sol9-sparc-local.gz" file using pkgadd -d command.
> Any othe configuration required????

When I build PostgreSQL on Solaris 9, I run configure with the following
options (amongst others not shown):

configure --with-tcl --with-tclconfig=/usr/local/lib

Try rebuilding and reinstalling PostgreSQL with those options and see if you
can then createlang pltclu.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq