This may already be a reported or known issue, but when I installed LDAP Integration package, it creates ldapauth, but it does not alter the table for Group and Data modules. The cause seems to be that alter syntaxes did not work with Postgres. I have tried HEAD, 5.x-2.x-dev and 5.x-1.3; all of them behaved that way.
Based on the error messages, I reconstructed the alter statements a la Postgres (as far as I am concerned) and it works like a charm thereon.
I do not exactly remember the difference in sql codes, but it was something like:
alter table ldapauth add ({field_def1},{field_def2},{field_defn});
And I made:
alter table ldapauth
add {field_def1},
add {field_def2},
add {field_defn};
to work with my database.
The version I was using was:
PostgreSQL 8.2.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)
Comments
Comment #1
johnbarclay commentedComment #2
cgmonroe commentedClosing because nobody using 6.x has reported this problem with PostGres. Probably because if I remember right the core db_* functions got more PostGres friendly than 5.