Hello.
I use PostgreSQL 7.1.3 for our intranet database.
I am working on building an LDAP directory based on the info provided
by the intranet database. Currently the only available method for
updating this LDAP directory is to delete all records then rebuild
them from scratch. This is quite dirty, and really too long, and this
is not acceptable for the Netscape roaming profiles.
I thought to write scripts that would be called through triggers in
the database, then would generate ldif files for updating LDAP with
just the necessary information. But then I saw the message from Tom
Lane (http://www.geocrawler.com/mail/msg.php3?msg_id=5446222&list=6),
and decided not follow this design. But now I am a bit stucked.
Perhaps I can use a sort of logging table containing create/old/new
values for a particular field of a table, and extract modified data
from here. I am not sure that this will work. Did anyone implemented
such a functionnality ? Am I going the wrong way ?
Thanks in advance.
Nicolas.