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

johnbarclay’s picture

Version: master » 6.x-1.x-dev
cgmonroe’s picture

Status: Active » Fixed

Closing 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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.