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(at)home(dot)com

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

Lamar Owen <lamar(dot)owen(at)wgcr(dot)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(at)home(dot)com

>
> 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(at)debis(dot)com (Jan Wieck) #