[GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread David R Robison
I have an LDAP directory that contains contact information and a PostgreSQL table that has contact names. What I want to do is write a SELECT that will join the names in the table with the data in the LDAP directory (such as phone number, e-mail address, etc). Is this possible? Has anyone done

Re: [GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread Magnus Hagander
David R Robison wrote: I have an LDAP directory that contains contact information and a PostgreSQL table that has contact names. What I want to do is write a SELECT that will join the names in the table with the data in the LDAP directory (such as phone number, e-mail address, etc). Is this

Re: [GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread David R Robison
Thanks, I found the extension but no documentation on how to install it or use it. Can you give me some pointers? TNX David Magnus Hagander wrote: David R Robison wrote: I have an LDAP directory that contains contact information and a PostgreSQL table that has contact names. What I want to

Re: [GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread David R Robison
I copied the file to the lib directory under the PostgreSQL install and ran the SQL command: CREATE FUNCTION ldap_search(text, text, text, text,text,text) RETURNS SETOF RECORD AS 'libdblink-ldap.dll', 'pg_ldap_search' LANGUAGE C STABLE; it gave me the following error: ERROR: incompatible

Re: [GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread Magnus Hagander
IIRC the binary release that's on there is too old to be supported on recent versions of PostgreSQL. You will need to build it from source, which should be patched with the magic block. //Magnus David R Robison wrote: I copied the file to the lib directory under the PostgreSQL install and ran

Re: [GENERAL] Doing an LDAP lookup from a SQL SELECT

2008-07-31 Thread David R Robison
I cannot seem to create an environment to recompile the DLL. Does anyone have a compiled version of the DLL that is compatible with PostgreSQL 8.2 that they can share with me? TNX David Magnus Hagander wrote: IIRC the binary release that's on there is too old to be supported on recent