Thread

1. Problem enabling pltcl

   Patrick Logan <patrick@c837917-a.potlnd1.or.home.com> — 1999-09-08T16:49:09Z

   I have configured, built, and installed ProsgreSQL 6.5.1 using:
   
       --with-tcl and --with-tkconfig=<dir>
   
   As far as I have looked, everything was built and installed without a
   hitch. The pltcl library is in the right location, and /etc/ld.so.conf
   lists that directory.
   
   When I define a function using pltcl I get the following:
   
       ERROR: Unrecognized language specified in a CREATE FUNCTION:
       'pltcl'.  Recognized languages are sql, C, internal and the
       created procedural languages.
   
   The docs say that pltcl is enabled if it is built with the TCL
   option. What am I missing?
   
   Thanks
   -- 
   Patrick Logan    patrickdlogan@home.com
   
   

2. Re: [HACKERS] Problem enabling pltcl

   Lamar Owen <lamar.owen@wgcr.org> — 1999-09-08T17:30:10Z

   Patrick Logan wrote:
   >     ERROR: Unrecognized language specified in a CREATE FUNCTION:
   >     'pltcl'.  Recognized languages are sql, C, internal and the
   >     created procedural languages.
   > 
   > The docs say that pltcl is enabled if it is built with the TCL
   > option. What am I missing?
   
   CREATE LANGUAGE (command line utility 'createlang').  See the regression
   test shell script (src/test/regress/regress.sh) for an example using
   plpgsql.  The PL's are not created and installed by default, apparently.
   
   Lamar Owen
   WGCR Internet Radio
   
   

3. Re: Problem enabling pltcl

   Patrick Logan <patrick@c837917-a.potlnd1.or.home.com> — 1999-09-08T20:32:09Z

   Lamar Owen <lamar.owen@wgcr.org> wrote:
   : Patrick Logan wrote:
   :>     ERROR: Unrecognized language specified in a CREATE FUNCTION:
   :>     'pltcl'.  Recognized languages are sql, C, internal and the
   :>     created procedural languages.
   :> 
   :> The docs say that pltcl is enabled if it is built with the TCL
   :> option. What am I missing?
   
   : CREATE LANGUAGE (command line utility 'createlang').  See the regression
   : test shell script (src/test/regress/regress.sh) for an example using
   : plpgsql.  The PL's are not created and installed by default, apparently.
   
   Thanks. I also had to create the handler function as per the
   documentation for creating new procedural language interfaces.
   
   Boy, the documentation sure read to me like all that was supposed to
   be done automatically by the Makefile when configured for pltcl.
   
   Not a big deal, but it wasn't clear to me this had to be done for each
   database created. Is this a bug in the documentation?
   
   -- 
   Patrick Logan    patrickdlogan@home.com
   
   

4. Re: [HACKERS] Problem enabling pltcl

   Jan Wieck <wieck@debis.com> — 1999-09-09T10:53:10Z

   >
   > Patrick Logan wrote:
   > >     ERROR: Unrecognized language specified in a CREATE FUNCTION:
   > >     'pltcl'.  Recognized languages are sql, C, internal and the
   > >     created procedural languages.
   > >
   > > The docs say that pltcl is enabled if it is built with the TCL
   > > option. What am I missing?
   >
   > CREATE LANGUAGE (command line utility 'createlang').  See the regression
   > test shell script (src/test/regress/regress.sh) for an example using
   > plpgsql.  The PL's are not created and installed by default, apparently.
   
       Yepp  -  it's  a doc mistake because first I made it that way
       and we decided later not to install by default into template1
       and provide createlang instead.
   
   
   Jan
   
   --
   
   #======================================================================#
   # It's easier to get forgiveness for being wrong than for being right. #
   # Let's break this rule - forgive me.                                  #
   #========================================= wieck@debis.com (Jan Wieck) #