pltcl and LDAP

Hi,

I posted this a few days ago on the pgsql-sql list, but got no response. Is
there any way to enable loading tclLDAP from within a pltcl function? I
would like to maintain an openldap directory using an update/insert trigger.

I modified pltcl.c to load a non-safe interpreter and recompiled. This
allowed me to use the "load" command, but the tclLDAP library still would
not load. The error message is:

ERROR: pltcl: couldn't load file "/usr/lib/tclLDAP/Ldap.so":
/usr/lib/tclLDAP/Ldap.so: undefined symbol: Tcl_PkgProvide (#1)

I am not even close to being fluent in c. I would greatly appreciate any
suggestions.

BTW, perhaps in some future release you might consider allowing a non-safe
tcl interpreter (or at least some kind of controlled external library
support) as an option.

Thanks,

Joe Conway

-----Original Message-----
From: Joe Conway <jconway2(at)home(dot)com>
To: pgsql-sql(at)postgresql(dot)org <pgsql-sql(at)postgresql(dot)org>
Date: Sunday, February 20, 2000 11:55 AM
Subject: pltcl and LDAP

>I'm working on a project right now which involves updating an LDAP
directory
>from a PostgreSQL database. The database includes a table called
>employee_data. I would like to use the tclLDAP library from within a pltcl
>function and create a trigger on the employee_data table to update the LDAP
>directory every time something changes.
>
>I have been able to get the tclLDAP functions to work properly from with
>pgtclsh, but not from within pltcl. The documentation states that pltcl
uses
>a safe interpreter which does not allow a tcl load command.
>
>Has anyone else tried to do this, i.e. synch up a PostgreSQL database with
a
>LDAP directory? If so, how? I have considered just writing a pgtclsh script
>and running it from cron, but I would prefer real time updates via a
trigger
>if possible.
>
>Any help or suggestions would be much appreciated.
>
>Thanks,
>
>Joe
>